******SET YOUR DIRECTORY to ...\replication

clear all


///////////////////////////////////////////////////////////////////////////////////////////
///1975-1983///////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////
***1960
infile using "cleaning\ucrdict_1960.dct", clear
save rawdata\UCR\ucr_m, replace
***1961-1966
forvalues i=1961/1974{
infile using "cleaning\ucrdict_`i'.dct", clear
drop if ori=="VA02101" & pop1==0 & (year==1967 | year==1970)
replace ori="VA02901" if ori=="SC02901" & agencyst=="VA" & year==1972
merge 1:1 ori year using rawdata\UCR\ucr_m
drop _merge
save rawdata\UCR\ucr_m, replace
}
///////////////////////////////////////////////////////////////////////////////////////////
///1975-1983///////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////
***1975-1979
forvalues i=1975/1979{
infile using "cleaning\ucrdict_`i'.dct", clear
drop if year==99
merge 1:1 ori year using rawdata\UCR\ucr_m
drop _merge
save rawdata\UCR\ucr_m, replace
}
***1980
use rawdata\UCR\09028-1980-Data.dta, clear
rename V1  icpsr_stnum
rename V2  icpsr_ednum
rename V3  icpsr_partnum
rename V4  icpsr_seqid
rename V5  id_code
rename V6  state
rename V7 ori
rename V8 group
rename V9  division
rename V10  year
rename V11 cityseq
rename V12 corecity
rename V13  update
rename V14 field
rename V15  nummonth
rename V16  agencycount
rename V17  pop1
rename V18  cty1
rename V19  smsa1
rename V20  pop2
rename V21  cty2
rename V22  smsa2
rename V23  pop3
rename V24  cty3
rename V25  smsa3
rename V26 followup
rename V27 specialmailg
rename V28 specialmaila
rename V29  agency
rename V30 agencyst
rename V31  address1
rename V32  address2
rename V33  address3
rename V34  address4
rename V35  zip
rename V36  monthincl1
rename V37  datelastup1
rename V38  card0type1
rename V39  card1type1
rename V40  card2type1
rename V41  card3type1
rename V42  card4type1
rename V43 card0pt1
rename V44 card1pt1
rename V45 card2pt1
rename V46 card3pt1
rename V47  offensesunf_1c1
rename V48  offensesunf_2c1
rename V49  offensesunf_3c1
rename V50  offensesunf_4c1
rename V51  offensesunf_5c1
rename V52  offensesunf_6c1
rename V53  offensesunf_7c1
rename V54  offensesunf_8c1
rename V55  offensesunf_9c1
rename V56  offensesunf_10c1
rename V57  offensesunf_11c1
rename V58  offensesunf_12c1
rename V59  offensesunf_13c1
rename V60  offensesunf_14c1
rename V61  offensesunf_15c1
rename V62  offensesunf_16c1
rename V63  offensesunf_17c1
rename V64  offensesunf_18c1
rename V65  offensesunf_19c1
rename V66  offensesunf_20c1
rename V67  offensesunf_21c1
rename V68  offensesunf_22c1
rename V69  offensesunf_23c1
rename V70  offensesunf_24c1
rename V71  offensesunf_25c1
rename V72  offensesunf_26c1
rename V73  offenses_1c1
rename V74  offenses_2c1
rename V75  offenses_3c1
rename V76  offenses_4c1
rename V77  offenses_5c1
rename V78  offenses_6c1
rename V79  offenses_7c1
rename V80  offenses_8c1
rename V81  offenses_9c1
rename V82  offenses_10c1
rename V83  offenses_11c1
rename V84  offenses_12c1
rename V85  offenses_13c1
rename V86  offenses_14c1
rename V87  offenses_15c1
rename V88  offenses_16c1
rename V89  offenses_17c1
rename V90  offenses_18c1
rename V91  offenses_19c1
rename V92  offenses_20c1
rename V93  offenses_21c1
rename V94  offenses_22c1
rename V95  offenses_23c1
rename V96  offenses_24c1
rename V97  offenses_25c1
rename V98  offenses_26c1
rename V99  clearances_1c1
rename V100  clearances_2c1
rename V101  clearances_3c1
rename V102  clearances_4c1
rename V103  clearances_5c1
rename V104  clearances_6c1
rename V105  clearances_7c1
rename V106  clearances_8c1
rename V107  clearances_9c1
rename V108  clearances_10c1
rename V109  clearances_11c1
rename V110  clearances_12c1
rename V111  clearances_13c1
rename V112  clearances_14c1
rename V113  clearances_15c1
rename V114  clearances_16c1
rename V115  clearances_17c1
rename V116  clearances_18c1
rename V117  clearances_19c1
rename V118  clearances_20c1
rename V119  clearances_21c1
rename V120  clearances_22c1
rename V121  clearances_23c1
rename V122  clearances_24c1
rename V123  clearances_25c1
rename V124  clearances_26c1
rename V125  clearancesu18_1c1
rename V126  clearancesu18_2c1
rename V127  clearancesu18_3c1
rename V128  clearancesu18_4c1
rename V129  clearancesu18_5c1
rename V130  clearancesu18_6c1
rename V131  clearancesu18_7c1
rename V132  clearancesu18_8c1
rename V133  clearancesu18_9c1
rename V134  clearancesu18_10c1
rename V135  clearancesu18_11c1
rename V136  clearancesu18_12c1
rename V137  clearancesu18_13c1
rename V138  clearancesu18_14c1
rename V139  clearancesu18_15c1
rename V140  clearancesu18_16c1
rename V141  clearancesu18_17c1
rename V142  clearancesu18_18c1
rename V143  clearancesu18_19c1
rename V144  clearancesu18_20c1
rename V145  clearancesu18_21c1
rename V146  clearancesu18_22c1
rename V147  clearancesu18_23c1
rename V148  clearancesu18_24c1
rename V149  clearancesu18_25c1
rename V150  clearancesu18_26c1
rename V151  felonious1
rename V152  accidental1
rename V153  officerass1
rename V154  monthincl2
rename V155  datelastup2
rename V156  card0type2
rename V157  card1type2
rename V158  card2type2
rename V159  card3type2
rename V160  card4type2
rename V161 card0pt2
rename V162 card1pt2
rename V163 card2pt2
rename V164 card3pt2
rename V165  offensesunf_1c2
rename V166  offensesunf_2c2
rename V167  offensesunf_3c2
rename V168  offensesunf_4c2
rename V169  offensesunf_5c2
rename V170  offensesunf_6c2
rename V171  offensesunf_7c2
rename V172  offensesunf_8c2
rename V173  offensesunf_9c2
rename V174  offensesunf_10c2
rename V175  offensesunf_11c2
rename V176  offensesunf_12c2
rename V177  offensesunf_13c2
rename V178  offensesunf_14c2
rename V179  offensesunf_15c2
rename V180  offensesunf_16c2
rename V181  offensesunf_17c2
rename V182  offensesunf_18c2
rename V183  offensesunf_19c2
rename V184  offensesunf_20c2
rename V185  offensesunf_21c2
rename V186  offensesunf_22c2
rename V187  offensesunf_23c2
rename V188  offensesunf_24c2
rename V189  offensesunf_25c2
rename V190  offensesunf_26c2
rename V191  offenses_1c2
rename V192  offenses_2c2
rename V193  offenses_3c2
rename V194  offenses_4c2
rename V195  offenses_5c2
rename V196  offenses_6c2
rename V197  offenses_7c2
rename V198  offenses_8c2
rename V199  offenses_9c2
rename V200  offenses_10c2
rename V201  offenses_11c2
rename V202  offenses_12c2
rename V203  offenses_13c2
rename V204  offenses_14c2
rename V205  offenses_15c2
rename V206  offenses_16c2
rename V207  offenses_17c2
rename V208  offenses_18c2
rename V209  offenses_19c2
rename V210  offenses_20c2
rename V211  offenses_21c2
rename V212  offenses_22c2
rename V213  offenses_23c2
rename V214  offenses_24c2
rename V215  offenses_25c2
rename V216  offenses_26c2
rename V217  clearances_1c2
rename V218  clearances_2c2
rename V219  clearances_3c2
rename V220  clearances_4c2
rename V221  clearances_5c2
rename V222  clearances_6c2
rename V223  clearances_7c2
rename V224  clearances_8c2
rename V225  clearances_9c2
rename V226  clearances_10c2
rename V227  clearances_11c2
rename V228  clearances_12c2
rename V229  clearances_13c2
rename V230  clearances_14c2
rename V231  clearances_15c2
rename V232  clearances_16c2
rename V233  clearances_17c2
rename V234  clearances_18c2
rename V235  clearances_19c2
rename V236  clearances_20c2
rename V237  clearances_21c2
rename V238  clearances_22c2
rename V239  clearances_23c2
rename V240  clearances_24c2
rename V241  clearances_25c2
rename V242  clearances_26c2
rename V243  clearancesu18_1c2
rename V244  clearancesu18_2c2
rename V245  clearancesu18_3c2
rename V246  clearancesu18_4c2
rename V247  clearancesu18_5c2
rename V248  clearancesu18_6c2
rename V249  clearancesu18_7c2
rename V250  clearancesu18_8c2
rename V251  clearancesu18_9c2
rename V252  clearancesu18_10c2
rename V253  clearancesu18_11c2
rename V254  clearancesu18_12c2
rename V255  clearancesu18_13c2
rename V256  clearancesu18_14c2
rename V257  clearancesu18_15c2
rename V258  clearancesu18_16c2
rename V259  clearancesu18_17c2
rename V260  clearancesu18_18c2
rename V261  clearancesu18_19c2
rename V262  clearancesu18_20c2
rename V263  clearancesu18_21c2
rename V264  clearancesu18_22c2
rename V265  clearancesu18_23c2
rename V266  clearancesu18_24c2
rename V267  clearancesu18_25c2
rename V268  clearancesu18_26c2
rename V269  felonious2
rename V270  accidental2
rename V271  officerass2
rename V272  monthincl3
rename V273  datelastup3
rename V274  card0type3
rename V275  card1type3
rename V276  card2type3
rename V277  card3type3
rename V278  card4type3
rename V279 card0pt3
rename V280 card1pt3
rename V281 card2pt3
rename V282 card3pt3
rename V283  offensesunf_1c3
rename V284  offensesunf_2c3
rename V285  offensesunf_3c3
rename V286  offensesunf_4c3
rename V287  offensesunf_5c3
rename V288  offensesunf_6c3
rename V289  offensesunf_7c3
rename V290  offensesunf_8c3
rename V291  offensesunf_9c3
rename V292  offensesunf_10c3
rename V293  offensesunf_11c3
rename V294  offensesunf_12c3
rename V295  offensesunf_13c3
rename V296  offensesunf_14c3
rename V297  offensesunf_15c3
rename V298  offensesunf_16c3
rename V299  offensesunf_17c3
rename V300  offensesunf_18c3
rename V301  offensesunf_19c3
rename V302  offensesunf_20c3
rename V303  offensesunf_21c3
rename V304  offensesunf_22c3
rename V305  offensesunf_23c3
rename V306  offensesunf_24c3
rename V307  offensesunf_25c3
rename V308  offensesunf_26c3
rename V309  offenses_1c3
rename V310  offenses_2c3
rename V311  offenses_3c3
rename V312  offenses_4c3
rename V313  offenses_5c3
rename V314  offenses_6c3
rename V315  offenses_7c3
rename V316  offenses_8c3
rename V317  offenses_9c3
rename V318  offenses_10c3
rename V319  offenses_11c3
rename V320  offenses_12c3
rename V321  offenses_13c3
rename V322  offenses_14c3
rename V323  offenses_15c3
rename V324  offenses_16c3
rename V325  offenses_17c3
rename V326  offenses_18c3
rename V327  offenses_19c3
rename V328  offenses_20c3
rename V329  offenses_21c3
rename V330  offenses_22c3
rename V331  offenses_23c3
rename V332  offenses_24c3
rename V333  offenses_25c3
rename V334  offenses_26c3
rename V335  clearances_1c3
rename V336  clearances_2c3
rename V337  clearances_3c3
rename V338  clearances_4c3
rename V339  clearances_5c3
rename V340  clearances_6c3
rename V341  clearances_7c3
rename V342  clearances_8c3
rename V343  clearances_9c3
rename V344  clearances_10c3
rename V345  clearances_11c3
rename V346  clearances_12c3
rename V347  clearances_13c3
rename V348  clearances_14c3
rename V349  clearances_15c3
rename V350  clearances_16c3
rename V351  clearances_17c3
rename V352  clearances_18c3
rename V353  clearances_19c3
rename V354  clearances_20c3
rename V355  clearances_21c3
rename V356  clearances_22c3
rename V357  clearances_23c3
rename V358  clearances_24c3
rename V359  clearances_25c3
rename V360  clearances_26c3
rename V361  clearancesu18_1c3
rename V362  clearancesu18_2c3
rename V363  clearancesu18_3c3
rename V364  clearancesu18_4c3
rename V365  clearancesu18_5c3
rename V366  clearancesu18_6c3
rename V367  clearancesu18_7c3
rename V368  clearancesu18_8c3
rename V369  clearancesu18_9c3
rename V370  clearancesu18_10c3
rename V371  clearancesu18_11c3
rename V372  clearancesu18_12c3
rename V373  clearancesu18_13c3
rename V374  clearancesu18_14c3
rename V375  clearancesu18_15c3
rename V376  clearancesu18_16c3
rename V377  clearancesu18_17c3
rename V378  clearancesu18_18c3
rename V379  clearancesu18_19c3
rename V380  clearancesu18_20c3
rename V381  clearancesu18_21c3
rename V382  clearancesu18_22c3
rename V383  clearancesu18_23c3
rename V384  clearancesu18_24c3
rename V385  clearancesu18_25c3
rename V386  clearancesu18_26c3
rename V387  felonious3
rename V388  accidental3
rename V389  officerass3
rename V390  monthincl4
rename V391  datelastup4
rename V392  card0type4
rename V393  card1type4
rename V394  card2type4
rename V395  card3type4
rename V396  card4type4
rename V397 card0pt4
rename V398 card1pt4
rename V399 card2pt4
rename V400 card3pt4
rename V401  offensesunf_1c4
rename V402  offensesunf_2c4
rename V403  offensesunf_3c4
rename V404  offensesunf_4c4
rename V405  offensesunf_5c4
rename V406  offensesunf_6c4
rename V407  offensesunf_7c4
rename V408  offensesunf_8c4
rename V409  offensesunf_9c4
rename V410  offensesunf_10c4
rename V411  offensesunf_11c4
rename V412  offensesunf_12c4
rename V413  offensesunf_13c4
rename V414  offensesunf_14c4
rename V415  offensesunf_15c4
rename V416  offensesunf_16c4
rename V417  offensesunf_17c4
rename V418  offensesunf_18c4
rename V419  offensesunf_19c4
rename V420  offensesunf_20c4
rename V421  offensesunf_21c4
rename V422  offensesunf_22c4
rename V423  offensesunf_23c4
rename V424  offensesunf_24c4
rename V425  offensesunf_25c4
rename V426  offensesunf_26c4
rename V427  offenses_1c4
rename V428  offenses_2c4
rename V429  offenses_3c4
rename V430  offenses_4c4
rename V431  offenses_5c4
rename V432  offenses_6c4
rename V433  offenses_7c4
rename V434  offenses_8c4
rename V435  offenses_9c4
rename V436  offenses_10c4
rename V437  offenses_11c4
rename V438  offenses_12c4
rename V439  offenses_13c4
rename V440  offenses_14c4
rename V441  offenses_15c4
rename V442  offenses_16c4
rename V443  offenses_17c4
rename V444  offenses_18c4
rename V445  offenses_19c4
rename V446  offenses_20c4
rename V447  offenses_21c4
rename V448  offenses_22c4
rename V449  offenses_23c4
rename V450  offenses_24c4
rename V451  offenses_25c4
rename V452  offenses_26c4
rename V453  clearances_1c4
rename V454  clearances_2c4
rename V455  clearances_3c4
rename V456  clearances_4c4
rename V457  clearances_5c4
rename V458  clearances_6c4
rename V459  clearances_7c4
rename V460  clearances_8c4
rename V461  clearances_9c4
rename V462  clearances_10c4
rename V463  clearances_11c4
rename V464  clearances_12c4
rename V465  clearances_13c4
rename V466  clearances_14c4
rename V467  clearances_15c4
rename V468  clearances_16c4
rename V469  clearances_17c4
rename V470  clearances_18c4
rename V471  clearances_19c4
rename V472  clearances_20c4
rename V473  clearances_21c4
rename V474  clearances_22c4
rename V475  clearances_23c4
rename V476  clearances_24c4
rename V477  clearances_25c4
rename V478  clearances_26c4
rename V479  clearancesu18_1c4
rename V480  clearancesu18_2c4
rename V481  clearancesu18_3c4
rename V482  clearancesu18_4c4
rename V483  clearancesu18_5c4
rename V484  clearancesu18_6c4
rename V485  clearancesu18_7c4
rename V486  clearancesu18_8c4
rename V487  clearancesu18_9c4
rename V488  clearancesu18_10c4
rename V489  clearancesu18_11c4
rename V490  clearancesu18_12c4
rename V491  clearancesu18_13c4
rename V492  clearancesu18_14c4
rename V493  clearancesu18_15c4
rename V494  clearancesu18_16c4
rename V495  clearancesu18_17c4
rename V496  clearancesu18_18c4
rename V497  clearancesu18_19c4
rename V498  clearancesu18_20c4
rename V499  clearancesu18_21c4
rename V500  clearancesu18_22c4
rename V501  clearancesu18_23c4
rename V502  clearancesu18_24c4
rename V503  clearancesu18_25c4
rename V504  clearancesu18_26c4
rename V505  felonious4
rename V506  accidental4
rename V507  officerass4
rename V508  monthincl5
rename V509  datelastup5
rename V510  card0type5
rename V511  card1type5
rename V512  card2type5
rename V513  card3type5
rename V514  card4type5
rename V515 card0pt5
rename V516 card1pt5
rename V517 card2pt5
rename V518 card3pt5
rename V519  offensesunf_1c5
rename V520  offensesunf_2c5
rename V521  offensesunf_3c5
rename V522  offensesunf_4c5
rename V523  offensesunf_5c5
rename V524  offensesunf_6c5
rename V525  offensesunf_7c5
rename V526  offensesunf_8c5
rename V527  offensesunf_9c5
rename V528  offensesunf_10c5
rename V529  offensesunf_11c5
rename V530  offensesunf_12c5
rename V531  offensesunf_13c5
rename V532  offensesunf_14c5
rename V533  offensesunf_15c5
rename V534  offensesunf_16c5
rename V535  offensesunf_17c5
rename V536  offensesunf_18c5
rename V537  offensesunf_19c5
rename V538  offensesunf_20c5
rename V539  offensesunf_21c5
rename V540  offensesunf_22c5
rename V541  offensesunf_23c5
rename V542  offensesunf_24c5
rename V543  offensesunf_25c5
rename V544  offensesunf_26c5
rename V545  offenses_1c5
rename V546  offenses_2c5
rename V547  offenses_3c5
rename V548  offenses_4c5
rename V549  offenses_5c5
rename V550  offenses_6c5
rename V551  offenses_7c5
rename V552  offenses_8c5
rename V553  offenses_9c5
rename V554  offenses_10c5
rename V555  offenses_11c5
rename V556  offenses_12c5
rename V557  offenses_13c5
rename V558  offenses_14c5
rename V559  offenses_15c5
rename V560  offenses_16c5
rename V561  offenses_17c5
rename V562  offenses_18c5
rename V563  offenses_19c5
rename V564  offenses_20c5
rename V565  offenses_21c5
rename V566  offenses_22c5
rename V567  offenses_23c5
rename V568  offenses_24c5
rename V569  offenses_25c5
rename V570  offenses_26c5
rename V571  clearances_1c5
rename V572  clearances_2c5
rename V573  clearances_3c5
rename V574  clearances_4c5
rename V575  clearances_5c5
rename V576  clearances_6c5
rename V577  clearances_7c5
rename V578  clearances_8c5
rename V579  clearances_9c5
rename V580  clearances_10c5
rename V581  clearances_11c5
rename V582  clearances_12c5
rename V583  clearances_13c5
rename V584  clearances_14c5
rename V585  clearances_15c5
rename V586  clearances_16c5
rename V587  clearances_17c5
rename V588  clearances_18c5
rename V589  clearances_19c5
rename V590  clearances_20c5
rename V591  clearances_21c5
rename V592  clearances_22c5
rename V593  clearances_23c5
rename V594  clearances_24c5
rename V595  clearances_25c5
rename V596  clearances_26c5
rename V597  clearancesu18_1c5
rename V598  clearancesu18_2c5
rename V599  clearancesu18_3c5
rename V600  clearancesu18_4c5
rename V601  clearancesu18_5c5
rename V602  clearancesu18_6c5
rename V603  clearancesu18_7c5
rename V604  clearancesu18_8c5
rename V605  clearancesu18_9c5
rename V606  clearancesu18_10c5
rename V607  clearancesu18_11c5
rename V608  clearancesu18_12c5
rename V609  clearancesu18_13c5
rename V610  clearancesu18_14c5
rename V611  clearancesu18_15c5
rename V612  clearancesu18_16c5
rename V613  clearancesu18_17c5
rename V614  clearancesu18_18c5
rename V615  clearancesu18_19c5
rename V616  clearancesu18_20c5
rename V617  clearancesu18_21c5
rename V618  clearancesu18_22c5
rename V619  clearancesu18_23c5
rename V620  clearancesu18_24c5
rename V621  clearancesu18_25c5
rename V622  clearancesu18_26c5
rename V623  felonious5
rename V624  accidental5
rename V625  officerass5
rename V626  monthincl6
rename V627  datelastup6
rename V628  card0type6
rename V629  card1type6
rename V630  card2type6
rename V631  card3type6
rename V632  card4type6
rename V633 card0pt6
rename V634 card1pt6
rename V635 card2pt6
rename V636 card3pt6
rename V637  offensesunf_1c6
rename V638  offensesunf_2c6
rename V639  offensesunf_3c6
rename V640  offensesunf_4c6
rename V641  offensesunf_5c6
rename V642  offensesunf_6c6
rename V643  offensesunf_7c6
rename V644  offensesunf_8c6
rename V645  offensesunf_9c6
rename V646  offensesunf_10c6
rename V647  offensesunf_11c6
rename V648  offensesunf_12c6
rename V649  offensesunf_13c6
rename V650  offensesunf_14c6
rename V651  offensesunf_15c6
rename V652  offensesunf_16c6
rename V653  offensesunf_17c6
rename V654  offensesunf_18c6
rename V655  offensesunf_19c6
rename V656  offensesunf_20c6
rename V657  offensesunf_21c6
rename V658  offensesunf_22c6
rename V659  offensesunf_23c6
rename V660  offensesunf_24c6
rename V661  offensesunf_25c6
rename V662  offensesunf_26c6
rename V663  offenses_1c6
rename V664  offenses_2c6
rename V665  offenses_3c6
rename V666  offenses_4c6
rename V667  offenses_5c6
rename V668  offenses_6c6
rename V669  offenses_7c6
rename V670  offenses_8c6
rename V671  offenses_9c6
rename V672  offenses_10c6
rename V673  offenses_11c6
rename V674  offenses_12c6
rename V675  offenses_13c6
rename V676  offenses_14c6
rename V677  offenses_15c6
rename V678  offenses_16c6
rename V679  offenses_17c6
rename V680  offenses_18c6
rename V681  offenses_19c6
rename V682  offenses_20c6
rename V683  offenses_21c6
rename V684  offenses_22c6
rename V685  offenses_23c6
rename V686  offenses_24c6
rename V687  offenses_25c6
rename V688  offenses_26c6
rename V689  clearances_1c6
rename V690  clearances_2c6
rename V691  clearances_3c6
rename V692  clearances_4c6
rename V693  clearances_5c6
rename V694  clearances_6c6
rename V695  clearances_7c6
rename V696  clearances_8c6
rename V697  clearances_9c6
rename V698  clearances_10c6
rename V699  clearances_11c6
rename V700  clearances_12c6
rename V701  clearances_13c6
rename V702  clearances_14c6
rename V703  clearances_15c6
rename V704  clearances_16c6
rename V705  clearances_17c6
rename V706  clearances_18c6
rename V707  clearances_19c6
rename V708  clearances_20c6
rename V709  clearances_21c6
rename V710  clearances_22c6
rename V711  clearances_23c6
rename V712  clearances_24c6
rename V713  clearances_25c6
rename V714  clearances_26c6
rename V715  clearancesu18_1c6
rename V716  clearancesu18_2c6
rename V717  clearancesu18_3c6
rename V718  clearancesu18_4c6
rename V719  clearancesu18_5c6
rename V720  clearancesu18_6c6
rename V721  clearancesu18_7c6
rename V722  clearancesu18_8c6
rename V723  clearancesu18_9c6
rename V724  clearancesu18_10c6
rename V725  clearancesu18_11c6
rename V726  clearancesu18_12c6
rename V727  clearancesu18_13c6
rename V728  clearancesu18_14c6
rename V729  clearancesu18_15c6
rename V730  clearancesu18_16c6
rename V731  clearancesu18_17c6
rename V732  clearancesu18_18c6
rename V733  clearancesu18_19c6
rename V734  clearancesu18_20c6
rename V735  clearancesu18_21c6
rename V736  clearancesu18_22c6
rename V737  clearancesu18_23c6
rename V738  clearancesu18_24c6
rename V739  clearancesu18_25c6
rename V740  clearancesu18_26c6
rename V741  felonious6
rename V742  accidental6
rename V743  officerass6
rename V744  monthincl7
rename V745  datelastup7
rename V746  card0type7
rename V747  card1type7
rename V748  card2type7
rename V749  card3type7
rename V750  card4type7
rename V751 card0pt7
rename V752 card1pt7
rename V753 card2pt7
rename V754 card3pt7
rename V755  offensesunf_1c7
rename V756  offensesunf_2c7
rename V757  offensesunf_3c7
rename V758  offensesunf_4c7
rename V759  offensesunf_5c7
rename V760  offensesunf_6c7
rename V761  offensesunf_7c7
rename V762  offensesunf_8c7
rename V763  offensesunf_9c7
rename V764  offensesunf_10c7
rename V765  offensesunf_11c7
rename V766  offensesunf_12c7
rename V767  offensesunf_13c7
rename V768  offensesunf_14c7
rename V769  offensesunf_15c7
rename V770  offensesunf_16c7
rename V771  offensesunf_17c7
rename V772  offensesunf_18c7
rename V773  offensesunf_19c7
rename V774  offensesunf_20c7
rename V775  offensesunf_21c7
rename V776  offensesunf_22c7
rename V777  offensesunf_23c7
rename V778  offensesunf_24c7
rename V779  offensesunf_25c7
rename V780  offensesunf_26c7
rename V781  offenses_1c7
rename V782  offenses_2c7
rename V783  offenses_3c7
rename V784  offenses_4c7
rename V785  offenses_5c7
rename V786  offenses_6c7
rename V787  offenses_7c7
rename V788  offenses_8c7
rename V789  offenses_9c7
rename V790  offenses_10c7
rename V791  offenses_11c7
rename V792  offenses_12c7
rename V793  offenses_13c7
rename V794  offenses_14c7
rename V795  offenses_15c7
rename V796  offenses_16c7
rename V797  offenses_17c7
rename V798  offenses_18c7
rename V799  offenses_19c7
rename V800  offenses_20c7
rename V801  offenses_21c7
rename V802  offenses_22c7
rename V803  offenses_23c7
rename V804  offenses_24c7
rename V805  offenses_25c7
rename V806  offenses_26c7
rename V807  clearances_1c7
rename V808  clearances_2c7
rename V809  clearances_3c7
rename V810  clearances_4c7
rename V811  clearances_5c7
rename V812  clearances_6c7
rename V813  clearances_7c7
rename V814  clearances_8c7
rename V815  clearances_9c7
rename V816  clearances_10c7
rename V817  clearances_11c7
rename V818  clearances_12c7
rename V819  clearances_13c7
rename V820  clearances_14c7
rename V821  clearances_15c7
rename V822  clearances_16c7
rename V823  clearances_17c7
rename V824  clearances_18c7
rename V825  clearances_19c7
rename V826  clearances_20c7
rename V827  clearances_21c7
rename V828  clearances_22c7
rename V829  clearances_23c7
rename V830  clearances_24c7
rename V831  clearances_25c7
rename V832  clearances_26c7
rename V833  clearancesu18_1c7
rename V834  clearancesu18_2c7
rename V835  clearancesu18_3c7
rename V836  clearancesu18_4c7
rename V837  clearancesu18_5c7
rename V838  clearancesu18_6c7
rename V839  clearancesu18_7c7
rename V840  clearancesu18_8c7
rename V841  clearancesu18_9c7
rename V842  clearancesu18_10c7
rename V843  clearancesu18_11c7
rename V844  clearancesu18_12c7
rename V845  clearancesu18_13c7
rename V846  clearancesu18_14c7
rename V847  clearancesu18_15c7
rename V848  clearancesu18_16c7
rename V849  clearancesu18_17c7
rename V850  clearancesu18_18c7
rename V851  clearancesu18_19c7
rename V852  clearancesu18_20c7
rename V853  clearancesu18_21c7
rename V854  clearancesu18_22c7
rename V855  clearancesu18_23c7
rename V856  clearancesu18_24c7
rename V857  clearancesu18_25c7
rename V858  clearancesu18_26c7
rename V859  felonious7
rename V860  accidental7
rename V861  officerass7
rename V862  monthincl8
rename V863  datelastup8
rename V864  card0type8
rename V865  card1type8
rename V866  card2type8
rename V867  card3type8
rename V868  card4type8
rename V869 card0pt8
rename V870 card1pt8
rename V871 card2pt8
rename V872 card3pt8
rename V873  offensesunf_1c8
rename V874  offensesunf_2c8
rename V875  offensesunf_3c8
rename V876  offensesunf_4c8
rename V877  offensesunf_5c8
rename V878  offensesunf_6c8
rename V879  offensesunf_7c8
rename V880  offensesunf_8c8
rename V881  offensesunf_9c8
rename V882  offensesunf_10c8
rename V883  offensesunf_11c8
rename V884  offensesunf_12c8
rename V885  offensesunf_13c8
rename V886  offensesunf_14c8
rename V887  offensesunf_15c8
rename V888  offensesunf_16c8
rename V889  offensesunf_17c8
rename V890  offensesunf_18c8
rename V891  offensesunf_19c8
rename V892  offensesunf_20c8
rename V893  offensesunf_21c8
rename V894  offensesunf_22c8
rename V895  offensesunf_23c8
rename V896  offensesunf_24c8
rename V897  offensesunf_25c8
rename V898  offensesunf_26c8
rename V899  offenses_1c8
rename V900  offenses_2c8
rename V901  offenses_3c8
rename V902  offenses_4c8
rename V903  offenses_5c8
rename V904  offenses_6c8
rename V905  offenses_7c8
rename V906  offenses_8c8
rename V907  offenses_9c8
rename V908  offenses_10c8
rename V909  offenses_11c8
rename V910  offenses_12c8
rename V911  offenses_13c8
rename V912  offenses_14c8
rename V913  offenses_15c8
rename V914  offenses_16c8
rename V915  offenses_17c8
rename V916  offenses_18c8
rename V917  offenses_19c8
rename V918  offenses_20c8
rename V919  offenses_21c8
rename V920  offenses_22c8
rename V921  offenses_23c8
rename V922  offenses_24c8
rename V923  offenses_25c8
rename V924  offenses_26c8
rename V925  clearances_1c8
rename V926  clearances_2c8
rename V927  clearances_3c8
rename V928  clearances_4c8
rename V929  clearances_5c8
rename V930  clearances_6c8
rename V931  clearances_7c8
rename V932  clearances_8c8
rename V933  clearances_9c8
rename V934  clearances_10c8
rename V935  clearances_11c8
rename V936  clearances_12c8
rename V937  clearances_13c8
rename V938  clearances_14c8
rename V939  clearances_15c8
rename V940  clearances_16c8
rename V941  clearances_17c8
rename V942  clearances_18c8
rename V943  clearances_19c8
rename V944  clearances_20c8
rename V945  clearances_21c8
rename V946  clearances_22c8
rename V947  clearances_23c8
rename V948  clearances_24c8
rename V949  clearances_25c8
rename V950  clearances_26c8
rename V951  clearancesu18_1c8
rename V952  clearancesu18_2c8
rename V953  clearancesu18_3c8
rename V954  clearancesu18_4c8
rename V955  clearancesu18_5c8
rename V956  clearancesu18_6c8
rename V957  clearancesu18_7c8
rename V958  clearancesu18_8c8
rename V959  clearancesu18_9c8
rename V960  clearancesu18_10c8
rename V961  clearancesu18_11c8
rename V962  clearancesu18_12c8
rename V963  clearancesu18_13c8
rename V964  clearancesu18_14c8
rename V965  clearancesu18_15c8
rename V966  clearancesu18_16c8
rename V967  clearancesu18_17c8
rename V968  clearancesu18_18c8
rename V969  clearancesu18_19c8
rename V970  clearancesu18_20c8
rename V971  clearancesu18_21c8
rename V972  clearancesu18_22c8
rename V973  clearancesu18_23c8
rename V974  clearancesu18_24c8
rename V975  clearancesu18_25c8
rename V976  clearancesu18_26c8
rename V977  felonious8
rename V978  accidental8
rename V979  officerass8
rename V980  monthincl9
rename V981  datelastup9
rename V982  card0type9
rename V983  card1type9
rename V984  card2type9
rename V985  card3type9
rename V986  card4type9
rename V987 card0pt9
rename V988 card1pt9
rename V989 card2pt9
rename V990 card3pt9
rename V991  offensesunf_1c9
rename V992  offensesunf_2c9
rename V993  offensesunf_3c9
rename V994  offensesunf_4c9
rename V995  offensesunf_5c9
rename V996  offensesunf_6c9
rename V997  offensesunf_7c9
rename V998  offensesunf_8c9
rename V999  offensesunf_9c9
rename V1000  offensesunf_10c9
rename V1001  offensesunf_11c9
rename V1002  offensesunf_12c9
rename V1003  offensesunf_13c9
rename V1004  offensesunf_14c9
rename V1005  offensesunf_15c9
rename V1006  offensesunf_16c9
rename V1007  offensesunf_17c9
rename V1008  offensesunf_18c9
rename V1009  offensesunf_19c9
rename V1010  offensesunf_20c9
rename V1011  offensesunf_21c9
rename V1012  offensesunf_22c9
rename V1013  offensesunf_23c9
rename V1014  offensesunf_24c9
rename V1015  offensesunf_25c9
rename V1016  offensesunf_26c9
rename V1017  offenses_1c9
rename V1018  offenses_2c9
rename V1019  offenses_3c9
rename V1020  offenses_4c9
rename V1021  offenses_5c9
rename V1022  offenses_6c9
rename V1023  offenses_7c9
rename V1024  offenses_8c9
rename V1025  offenses_9c9
rename V1026  offenses_10c9
rename V1027  offenses_11c9
rename V1028  offenses_12c9
rename V1029  offenses_13c9
rename V1030  offenses_14c9
rename V1031  offenses_15c9
rename V1032  offenses_16c9
rename V1033  offenses_17c9
rename V1034  offenses_18c9
rename V1035  offenses_19c9
rename V1036  offenses_20c9
rename V1037  offenses_21c9
rename V1038  offenses_22c9
rename V1039  offenses_23c9
rename V1040  offenses_24c9
rename V1041  offenses_25c9
rename V1042  offenses_26c9
rename V1043  clearances_1c9
rename V1044  clearances_2c9
rename V1045  clearances_3c9
rename V1046  clearances_4c9
rename V1047  clearances_5c9
rename V1048  clearances_6c9
rename V1049  clearances_7c9
rename V1050  clearances_8c9
rename V1051  clearances_9c9
rename V1052  clearances_10c9
rename V1053  clearances_11c9
rename V1054  clearances_12c9
rename V1055  clearances_13c9
rename V1056  clearances_14c9
rename V1057  clearances_15c9
rename V1058  clearances_16c9
rename V1059  clearances_17c9
rename V1060  clearances_18c9
rename V1061  clearances_19c9
rename V1062  clearances_20c9
rename V1063  clearances_21c9
rename V1064  clearances_22c9
rename V1065  clearances_23c9
rename V1066  clearances_24c9
rename V1067  clearances_25c9
rename V1068  clearances_26c9
rename V1069  clearancesu18_1c9
rename V1070  clearancesu18_2c9
rename V1071  clearancesu18_3c9
rename V1072  clearancesu18_4c9
rename V1073  clearancesu18_5c9
rename V1074  clearancesu18_6c9
rename V1075  clearancesu18_7c9
rename V1076  clearancesu18_8c9
rename V1077  clearancesu18_9c9
rename V1078  clearancesu18_10c9
rename V1079  clearancesu18_11c9
rename V1080  clearancesu18_12c9
rename V1081  clearancesu18_13c9
rename V1082  clearancesu18_14c9
rename V1083  clearancesu18_15c9
rename V1084  clearancesu18_16c9
rename V1085  clearancesu18_17c9
rename V1086  clearancesu18_18c9
rename V1087  clearancesu18_19c9
rename V1088  clearancesu18_20c9
rename V1089  clearancesu18_21c9
rename V1090  clearancesu18_22c9
rename V1091  clearancesu18_23c9
rename V1092  clearancesu18_24c9
rename V1093  clearancesu18_25c9
rename V1094  clearancesu18_26c9
rename V1095  felonious9
rename V1096  accidental9
rename V1097  officerass9
rename V1098  monthincl10
rename V1099  datelastup10
rename V1100  card0type10
rename V1101  card1type10
rename V1102  card2type10
rename V1103  card3type10
rename V1104  card4type10
rename V1105 card0pt10
rename V1106 card1pt10
rename V1107 card2pt10
rename V1108 card3pt10
rename V1109  offensesunf_1c10
rename V1110  offensesunf_2c10
rename V1111  offensesunf_3c10
rename V1112  offensesunf_4c10
rename V1113  offensesunf_5c10
rename V1114  offensesunf_6c10
rename V1115  offensesunf_7c10
rename V1116  offensesunf_8c10
rename V1117  offensesunf_9c10
rename V1118  offensesunf_10c10
rename V1119  offensesunf_11c10
rename V1120  offensesunf_12c10
rename V1121  offensesunf_13c10
rename V1122  offensesunf_14c10
rename V1123  offensesunf_15c10
rename V1124  offensesunf_16c10
rename V1125  offensesunf_17c10
rename V1126  offensesunf_18c10
rename V1127  offensesunf_19c10
rename V1128  offensesunf_20c10
rename V1129  offensesunf_21c10
rename V1130  offensesunf_22c10
rename V1131  offensesunf_23c10
rename V1132  offensesunf_24c10
rename V1133  offensesunf_25c10
rename V1134  offensesunf_26c10
rename V1135  offenses_1c10
rename V1136  offenses_2c10
rename V1137  offenses_3c10
rename V1138  offenses_4c10
rename V1139  offenses_5c10
rename V1140  offenses_6c10
rename V1141  offenses_7c10
rename V1142  offenses_8c10
rename V1143  offenses_9c10
rename V1144  offenses_10c10
rename V1145  offenses_11c10
rename V1146  offenses_12c10
rename V1147  offenses_13c10
rename V1148  offenses_14c10
rename V1149  offenses_15c10
rename V1150  offenses_16c10
rename V1151  offenses_17c10
rename V1152  offenses_18c10
rename V1153  offenses_19c10
rename V1154  offenses_20c10
rename V1155  offenses_21c10
rename V1156  offenses_22c10
rename V1157  offenses_23c10
rename V1158  offenses_24c10
rename V1159  offenses_25c10
rename V1160  offenses_26c10
rename V1161  clearances_1c10
rename V1162  clearances_2c10
rename V1163  clearances_3c10
rename V1164  clearances_4c10
rename V1165  clearances_5c10
rename V1166  clearances_6c10
rename V1167  clearances_7c10
rename V1168  clearances_8c10
rename V1169  clearances_9c10
rename V1170  clearances_10c10
rename V1171  clearances_11c10
rename V1172  clearances_12c10
rename V1173  clearances_13c10
rename V1174  clearances_14c10
rename V1175  clearances_15c10
rename V1176  clearances_16c10
rename V1177  clearances_17c10
rename V1178  clearances_18c10
rename V1179  clearances_19c10
rename V1180  clearances_20c10
rename V1181  clearances_21c10
rename V1182  clearances_22c10
rename V1183  clearances_23c10
rename V1184  clearances_24c10
rename V1185  clearances_25c10
rename V1186  clearances_26c10
rename V1187  clearancesu18_1c10
rename V1188  clearancesu18_2c10
rename V1189  clearancesu18_3c10
rename V1190  clearancesu18_4c10
rename V1191  clearancesu18_5c10
rename V1192  clearancesu18_6c10
rename V1193  clearancesu18_7c10
rename V1194  clearancesu18_8c10
rename V1195  clearancesu18_9c10
rename V1196  clearancesu18_10c10
rename V1197  clearancesu18_11c10
rename V1198  clearancesu18_12c10
rename V1199  clearancesu18_13c10
rename V1200  clearancesu18_14c10
rename V1201  clearancesu18_15c10
rename V1202  clearancesu18_16c10
rename V1203  clearancesu18_17c10
rename V1204  clearancesu18_18c10
rename V1205  clearancesu18_19c10
rename V1206  clearancesu18_20c10
rename V1207  clearancesu18_21c10
rename V1208  clearancesu18_22c10
rename V1209  clearancesu18_23c10
rename V1210  clearancesu18_24c10
rename V1211  clearancesu18_25c10
rename V1212  clearancesu18_26c10
rename V1213  felonious10
rename V1214  accidental10
rename V1215  officerass10
rename V1216  monthincl11
rename V1217  datelastup11
rename V1218  card0type11
rename V1219  card1type11
rename V1220  card2type11
rename V1221  card3type11
rename V1222  card4type11
rename V1223 card0pt11
rename V1224 card1pt11
rename V1225 card2pt11
rename V1226 card3pt11
rename V1227  offensesunf_1c11
rename V1228  offensesunf_2c11
rename V1229  offensesunf_3c11
rename V1230  offensesunf_4c11
rename V1231  offensesunf_5c11
rename V1232  offensesunf_6c11
rename V1233  offensesunf_7c11
rename V1234  offensesunf_8c11
rename V1235  offensesunf_9c11
rename V1236  offensesunf_10c11
rename V1237  offensesunf_11c11
rename V1238  offensesunf_12c11
rename V1239  offensesunf_13c11
rename V1240  offensesunf_14c11
rename V1241  offensesunf_15c11
rename V1242  offensesunf_16c11
rename V1243  offensesunf_17c11
rename V1244  offensesunf_18c11
rename V1245  offensesunf_19c11
rename V1246  offensesunf_20c11
rename V1247  offensesunf_21c11
rename V1248  offensesunf_22c11
rename V1249  offensesunf_23c11
rename V1250  offensesunf_24c11
rename V1251  offensesunf_25c11
rename V1252  offensesunf_26c11
rename V1253  offenses_1c11
rename V1254  offenses_2c11
rename V1255  offenses_3c11
rename V1256  offenses_4c11
rename V1257  offenses_5c11
rename V1258  offenses_6c11
rename V1259  offenses_7c11
rename V1260  offenses_8c11
rename V1261  offenses_9c11
rename V1262  offenses_10c11
rename V1263  offenses_11c11
rename V1264  offenses_12c11
rename V1265  offenses_13c11
rename V1266  offenses_14c11
rename V1267  offenses_15c11
rename V1268  offenses_16c11
rename V1269  offenses_17c11
rename V1270  offenses_18c11
rename V1271  offenses_19c11
rename V1272  offenses_20c11
rename V1273  offenses_21c11
rename V1274  offenses_22c11
rename V1275  offenses_23c11
rename V1276  offenses_24c11
rename V1277  offenses_25c11
rename V1278  offenses_26c11
rename V1279  clearances_1c11
rename V1280  clearances_2c11
rename V1281  clearances_3c11
rename V1282  clearances_4c11
rename V1283  clearances_5c11
rename V1284  clearances_6c11
rename V1285  clearances_7c11
rename V1286  clearances_8c11
rename V1287  clearances_9c11
rename V1288  clearances_10c11
rename V1289  clearances_11c11
rename V1290  clearances_12c11
rename V1291  clearances_13c11
rename V1292  clearances_14c11
rename V1293  clearances_15c11
rename V1294  clearances_16c11
rename V1295  clearances_17c11
rename V1296  clearances_18c11
rename V1297  clearances_19c11
rename V1298  clearances_20c11
rename V1299  clearances_21c11
rename V1300  clearances_22c11
rename V1301  clearances_23c11
rename V1302  clearances_24c11
rename V1303  clearances_25c11
rename V1304  clearances_26c11
rename V1305  clearancesu18_1c11
rename V1306  clearancesu18_2c11
rename V1307  clearancesu18_3c11
rename V1308  clearancesu18_4c11
rename V1309  clearancesu18_5c11
rename V1310  clearancesu18_6c11
rename V1311  clearancesu18_7c11
rename V1312  clearancesu18_8c11
rename V1313  clearancesu18_9c11
rename V1314  clearancesu18_10c11
rename V1315  clearancesu18_11c11
rename V1316  clearancesu18_12c11
rename V1317  clearancesu18_13c11
rename V1318  clearancesu18_14c11
rename V1319  clearancesu18_15c11
rename V1320  clearancesu18_16c11
rename V1321  clearancesu18_17c11
rename V1322  clearancesu18_18c11
rename V1323  clearancesu18_19c11
rename V1324  clearancesu18_20c11
rename V1325  clearancesu18_21c11
rename V1326  clearancesu18_22c11
rename V1327  clearancesu18_23c11
rename V1328  clearancesu18_24c11
rename V1329  clearancesu18_25c11
rename V1330  clearancesu18_26c11
rename V1331  felonious11
rename V1332  accidental11
rename V1333  officerass11
rename V1334  monthincl12
rename V1335  datelastup12
rename V1336  card0type12
rename V1337  card1type12
rename V1338  card2type12
rename V1339  card3type12
rename V1340  card4type12
rename V1341 card0pt12
rename V1342 card1pt12
rename V1343 card2pt12
rename V1344 card3pt12
rename V1345  offensesunf_1c12
rename V1346  offensesunf_2c12
rename V1347  offensesunf_3c12
rename V1348  offensesunf_4c12
rename V1349  offensesunf_5c12
rename V1350  offensesunf_6c12
rename V1351  offensesunf_7c12
rename V1352  offensesunf_8c12
rename V1353  offensesunf_9c12
rename V1354  offensesunf_10c12
rename V1355  offensesunf_11c12
rename V1356  offensesunf_12c12
rename V1357  offensesunf_13c12
rename V1358  offensesunf_14c12
rename V1359  offensesunf_15c12
rename V1360  offensesunf_16c12
rename V1361  offensesunf_17c12
rename V1362  offensesunf_18c12
rename V1363  offensesunf_19c12
rename V1364  offensesunf_20c12
rename V1365  offensesunf_21c12
rename V1366  offensesunf_22c12
rename V1367  offensesunf_23c12
rename V1368  offensesunf_24c12
rename V1369  offensesunf_25c12
rename V1370  offensesunf_26c12
rename V1371  offenses_1c12
rename V1372  offenses_2c12
rename V1373  offenses_3c12
rename V1374  offenses_4c12
rename V1375  offenses_5c12
rename V1376  offenses_6c12
rename V1377  offenses_7c12
rename V1378  offenses_8c12
rename V1379  offenses_9c12
rename V1380  offenses_10c12
rename V1381  offenses_11c12
rename V1382  offenses_12c12
rename V1383  offenses_13c12
rename V1384  offenses_14c12
rename V1385  offenses_15c12
rename V1386  offenses_16c12
rename V1387  offenses_17c12
rename V1388  offenses_18c12
rename V1389  offenses_19c12
rename V1390  offenses_20c12
rename V1391  offenses_21c12
rename V1392  offenses_22c12
rename V1393  offenses_23c12
rename V1394  offenses_24c12
rename V1395  offenses_25c12
rename V1396  offenses_26c12
rename V1397  clearances_1c12
rename V1398  clearances_2c12
rename V1399  clearances_3c12
rename V1400  clearances_4c12
rename V1401  clearances_5c12
rename V1402  clearances_6c12
rename V1403  clearances_7c12
rename V1404  clearances_8c12
rename V1405  clearances_9c12
rename V1406  clearances_10c12
rename V1407  clearances_11c12
rename V1408  clearances_12c12
rename V1409  clearances_13c12
rename V1410  clearances_14c12
rename V1411  clearances_15c12
rename V1412  clearances_16c12
rename V1413  clearances_17c12
rename V1414  clearances_18c12
rename V1415  clearances_19c12
rename V1416  clearances_20c12
rename V1417  clearances_21c12
rename V1418  clearances_22c12
rename V1419  clearances_23c12
rename V1420  clearances_24c12
rename V1421  clearances_25c12
rename V1422  clearances_26c12
rename V1423  clearancesu18_1c12
rename V1424  clearancesu18_2c12
rename V1425  clearancesu18_3c12
rename V1426  clearancesu18_4c12
rename V1427  clearancesu18_5c12
rename V1428  clearancesu18_6c12
rename V1429  clearancesu18_7c12
rename V1430  clearancesu18_8c12
rename V1431  clearancesu18_9c12
rename V1432  clearancesu18_10c12
rename V1433  clearancesu18_11c12
rename V1434  clearancesu18_12c12
rename V1435  clearancesu18_13c12
rename V1436  clearancesu18_14c12
rename V1437  clearancesu18_15c12
rename V1438  clearancesu18_16c12
rename V1439  clearancesu18_17c12
rename V1440  clearancesu18_18c12
rename V1441  clearancesu18_19c12
rename V1442  clearancesu18_20c12
rename V1443  clearancesu18_21c12
rename V1444  clearancesu18_22c12
rename V1445  clearancesu18_23c12
rename V1446  clearancesu18_24c12
rename V1447  clearancesu18_25c12
rename V1448  clearancesu18_26c12
rename V1449  felonious12
rename V1450  accidental12
rename V1451  officerass12

tostring group, replace force
tostring corecity, replace force
tostring followup, replace force
tostring specialmaila, replace force

destring cty*, replace force
destring smsa*, replace force
replace cty1=. if cty1==999

merge 1:1 ori year using rawdata\UCR\ucr_m
drop _merge
save rawdata\UCR\ucr_m, replace

***1981-1983
forvalues i=1981/1983{
use rawdata\UCR\09028-`i'-Data.dta, clear
rename V1  id_code
rename V2  state
rename V3 ori
rename V4 group
rename V5  division
rename V6  year
rename V7 cityseq
rename V8 corecity
rename V9 cover
rename V10  update
rename V11 field
rename V12  nummonth
rename V13  agencycount
rename V14  pop1
rename V15  cty1
rename V16  smsa1
rename V17  pop2
rename V18  cty2
rename V19  smsa2
rename V20  pop3
rename V21  cty3
rename V22  smsa3
rename V23 followup
rename V24 specialmailg
rename V25 specialmaila
rename V26  agency
rename V27 agencyst
rename V28  address1
rename V29  address2
rename V30  address3
rename V31  address4
rename V32  zip
rename V33  monthincl1
rename V34  datelastup1
rename V35  card0type1
rename V36  card1type1
rename V37  card2type1
rename V38  card3type1
rename V39  card4type1
rename V40 card0pt1
rename V41 card1pt1
rename V42 card2pt1
rename V43 card3pt1
rename V44  offensesunf_1c1
rename V45  offensesunf_2c1
rename V46  offensesunf_3c1
rename V47  offensesunf_4c1
rename V48  offensesunf_5c1
rename V49  offensesunf_6c1
rename V50  offensesunf_7c1
rename V51  offensesunf_8c1
rename V52  offensesunf_9c1
rename V53  offensesunf_10c1
rename V54  offensesunf_11c1
rename V55  offensesunf_12c1
rename V56  offensesunf_13c1
rename V57  offensesunf_14c1
rename V58  offensesunf_15c1
rename V59  offensesunf_16c1
rename V60  offensesunf_17c1
rename V61  offensesunf_18c1
rename V62  offensesunf_19c1
rename V63  offensesunf_20c1
rename V64  offensesunf_21c1
rename V65  offensesunf_22c1
rename V66  offensesunf_23c1
rename V67  offensesunf_24c1
rename V68  offensesunf_25c1
rename V69  offensesunf_26c1
rename V70  offenses_1c1
rename V71  offenses_2c1
rename V72  offenses_3c1
rename V73  offenses_4c1
rename V74  offenses_5c1
rename V75  offenses_6c1
rename V76  offenses_7c1
rename V77  offenses_8c1
rename V78  offenses_9c1
rename V79  offenses_10c1
rename V80  offenses_11c1
rename V81  offenses_12c1
rename V82  offenses_13c1
rename V83  offenses_14c1
rename V84  offenses_15c1
rename V85  offenses_16c1
rename V86  offenses_17c1
rename V87  offenses_18c1
rename V88  offenses_19c1
rename V89  offenses_20c1
rename V90  offenses_21c1
rename V91  offenses_22c1
rename V92  offenses_23c1
rename V93  offenses_24c1
rename V94  offenses_25c1
rename V95  offenses_26c1
rename V96  clearances_1c1
rename V97  clearances_2c1
rename V98  clearances_3c1
rename V99  clearances_4c1
rename V100  clearances_5c1
rename V101  clearances_6c1
rename V102  clearances_7c1
rename V103  clearances_8c1
rename V104  clearances_9c1
rename V105  clearances_10c1
rename V106  clearances_11c1
rename V107  clearances_12c1
rename V108  clearances_13c1
rename V109  clearances_14c1
rename V110  clearances_15c1
rename V111  clearances_16c1
rename V112  clearances_17c1
rename V113  clearances_18c1
rename V114  clearances_19c1
rename V115  clearances_20c1
rename V116  clearances_21c1
rename V117  clearances_22c1
rename V118  clearances_23c1
rename V119  clearances_24c1
rename V120  clearances_25c1
rename V121  clearances_26c1
rename V122  clearancesu18_1c1
rename V123  clearancesu18_2c1
rename V124  clearancesu18_3c1
rename V125  clearancesu18_4c1
rename V126  clearancesu18_5c1
rename V127  clearancesu18_6c1
rename V128  clearancesu18_7c1
rename V129  clearancesu18_8c1
rename V130  clearancesu18_9c1
rename V131  clearancesu18_10c1
rename V132  clearancesu18_11c1
rename V133  clearancesu18_12c1
rename V134  clearancesu18_13c1
rename V135  clearancesu18_14c1
rename V136  clearancesu18_15c1
rename V137  clearancesu18_16c1
rename V138  clearancesu18_17c1
rename V139  clearancesu18_18c1
rename V140  clearancesu18_19c1
rename V141  clearancesu18_20c1
rename V142  clearancesu18_21c1
rename V143  clearancesu18_22c1
rename V144  clearancesu18_23c1
rename V145  clearancesu18_24c1
rename V146  clearancesu18_25c1
rename V147  clearancesu18_26c1
rename V148  felonious1
rename V149  accidental1
rename V150  officerass1
rename V151  monthincl2
rename V152  datelastup2
rename V153  card0type2
rename V154  card1type2
rename V155  card2type2
rename V156  card3type2
rename V157  card4type2
rename V158 card0pt2
rename V159 card1pt2
rename V160 card2pt2
rename V161 card3pt2
rename V162  offensesunf_1c2
rename V163  offensesunf_2c2
rename V164  offensesunf_3c2
rename V165  offensesunf_4c2
rename V166  offensesunf_5c2
rename V167  offensesunf_6c2
rename V168  offensesunf_7c2
rename V169  offensesunf_8c2
rename V170  offensesunf_9c2
rename V171  offensesunf_10c2
rename V172  offensesunf_11c2
rename V173  offensesunf_12c2
rename V174  offensesunf_13c2
rename V175  offensesunf_14c2
rename V176  offensesunf_15c2
rename V177  offensesunf_16c2
rename V178  offensesunf_17c2
rename V179  offensesunf_18c2
rename V180  offensesunf_19c2
rename V181  offensesunf_20c2
rename V182  offensesunf_21c2
rename V183  offensesunf_22c2
rename V184  offensesunf_23c2
rename V185  offensesunf_24c2
rename V186  offensesunf_25c2
rename V187  offensesunf_26c2
rename V188  offenses_1c2
rename V189  offenses_2c2
rename V190  offenses_3c2
rename V191  offenses_4c2
rename V192  offenses_5c2
rename V193  offenses_6c2
rename V194  offenses_7c2
rename V195  offenses_8c2
rename V196  offenses_9c2
rename V197  offenses_10c2
rename V198  offenses_11c2
rename V199  offenses_12c2
rename V200  offenses_13c2
rename V201  offenses_14c2
rename V202  offenses_15c2
rename V203  offenses_16c2
rename V204  offenses_17c2
rename V205  offenses_18c2
rename V206  offenses_19c2
rename V207  offenses_20c2
rename V208  offenses_21c2
rename V209  offenses_22c2
rename V210  offenses_23c2
rename V211  offenses_24c2
rename V212  offenses_25c2
rename V213  offenses_26c2
rename V214  clearances_1c2
rename V215  clearances_2c2
rename V216  clearances_3c2
rename V217  clearances_4c2
rename V218  clearances_5c2
rename V219  clearances_6c2
rename V220  clearances_7c2
rename V221  clearances_8c2
rename V222  clearances_9c2
rename V223  clearances_10c2
rename V224  clearances_11c2
rename V225  clearances_12c2
rename V226  clearances_13c2
rename V227  clearances_14c2
rename V228  clearances_15c2
rename V229  clearances_16c2
rename V230  clearances_17c2
rename V231  clearances_18c2
rename V232  clearances_19c2
rename V233  clearances_20c2
rename V234  clearances_21c2
rename V235  clearances_22c2
rename V236  clearances_23c2
rename V237  clearances_24c2
rename V238  clearances_25c2
rename V239  clearances_26c2
rename V240  clearancesu18_1c2
rename V241  clearancesu18_2c2
rename V242  clearancesu18_3c2
rename V243  clearancesu18_4c2
rename V244  clearancesu18_5c2
rename V245  clearancesu18_6c2
rename V246  clearancesu18_7c2
rename V247  clearancesu18_8c2
rename V248  clearancesu18_9c2
rename V249  clearancesu18_10c2
rename V250  clearancesu18_11c2
rename V251  clearancesu18_12c2
rename V252  clearancesu18_13c2
rename V253  clearancesu18_14c2
rename V254  clearancesu18_15c2
rename V255  clearancesu18_16c2
rename V256  clearancesu18_17c2
rename V257  clearancesu18_18c2
rename V258  clearancesu18_19c2
rename V259  clearancesu18_20c2
rename V260  clearancesu18_21c2
rename V261  clearancesu18_22c2
rename V262  clearancesu18_23c2
rename V263  clearancesu18_24c2
rename V264  clearancesu18_25c2
rename V265  clearancesu18_26c2
rename V266  felonious2
rename V267  accidental2
rename V268  officerass2
rename V269  monthincl3
rename V270  datelastup3
rename V271  card0type3
rename V272  card1type3
rename V273  card2type3
rename V274  card3type3
rename V275  card4type3
rename V276 card0pt3
rename V277 card1pt3
rename V278 card2pt3
rename V279 card3pt3
rename V280  offensesunf_1c3
rename V281  offensesunf_2c3
rename V282  offensesunf_3c3
rename V283  offensesunf_4c3
rename V284  offensesunf_5c3
rename V285  offensesunf_6c3
rename V286  offensesunf_7c3
rename V287  offensesunf_8c3
rename V288  offensesunf_9c3
rename V289  offensesunf_10c3
rename V290  offensesunf_11c3
rename V291  offensesunf_12c3
rename V292  offensesunf_13c3
rename V293  offensesunf_14c3
rename V294  offensesunf_15c3
rename V295  offensesunf_16c3
rename V296  offensesunf_17c3
rename V297  offensesunf_18c3
rename V298  offensesunf_19c3
rename V299  offensesunf_20c3
rename V300  offensesunf_21c3
rename V301  offensesunf_22c3
rename V302  offensesunf_23c3
rename V303  offensesunf_24c3
rename V304  offensesunf_25c3
rename V305  offensesunf_26c3
rename V306  offenses_1c3
rename V307  offenses_2c3
rename V308  offenses_3c3
rename V309  offenses_4c3
rename V310  offenses_5c3
rename V311  offenses_6c3
rename V312  offenses_7c3
rename V313  offenses_8c3
rename V314  offenses_9c3
rename V315  offenses_10c3
rename V316  offenses_11c3
rename V317  offenses_12c3
rename V318  offenses_13c3
rename V319  offenses_14c3
rename V320  offenses_15c3
rename V321  offenses_16c3
rename V322  offenses_17c3
rename V323  offenses_18c3
rename V324  offenses_19c3
rename V325  offenses_20c3
rename V326  offenses_21c3
rename V327  offenses_22c3
rename V328  offenses_23c3
rename V329  offenses_24c3
rename V330  offenses_25c3
rename V331  offenses_26c3
rename V332  clearances_1c3
rename V333  clearances_2c3
rename V334  clearances_3c3
rename V335  clearances_4c3
rename V336  clearances_5c3
rename V337  clearances_6c3
rename V338  clearances_7c3
rename V339  clearances_8c3
rename V340  clearances_9c3
rename V341  clearances_10c3
rename V342  clearances_11c3
rename V343  clearances_12c3
rename V344  clearances_13c3
rename V345  clearances_14c3
rename V346  clearances_15c3
rename V347  clearances_16c3
rename V348  clearances_17c3
rename V349  clearances_18c3
rename V350  clearances_19c3
rename V351  clearances_20c3
rename V352  clearances_21c3
rename V353  clearances_22c3
rename V354  clearances_23c3
rename V355  clearances_24c3
rename V356  clearances_25c3
rename V357  clearances_26c3
rename V358  clearancesu18_1c3
rename V359  clearancesu18_2c3
rename V360  clearancesu18_3c3
rename V361  clearancesu18_4c3
rename V362  clearancesu18_5c3
rename V363  clearancesu18_6c3
rename V364  clearancesu18_7c3
rename V365  clearancesu18_8c3
rename V366  clearancesu18_9c3
rename V367  clearancesu18_10c3
rename V368  clearancesu18_11c3
rename V369  clearancesu18_12c3
rename V370  clearancesu18_13c3
rename V371  clearancesu18_14c3
rename V372  clearancesu18_15c3
rename V373  clearancesu18_16c3
rename V374  clearancesu18_17c3
rename V375  clearancesu18_18c3
rename V376  clearancesu18_19c3
rename V377  clearancesu18_20c3
rename V378  clearancesu18_21c3
rename V379  clearancesu18_22c3
rename V380  clearancesu18_23c3
rename V381  clearancesu18_24c3
rename V382  clearancesu18_25c3
rename V383  clearancesu18_26c3
rename V384  felonious3
rename V385  accidental3
rename V386  officerass3
rename V387  monthincl4
rename V388  datelastup4
rename V389  card0type4
rename V390  card1type4
rename V391  card2type4
rename V392  card3type4
rename V393  card4type4
rename V394 card0pt4
rename V395 card1pt4
rename V396 card2pt4
rename V397 card3pt4
rename V398  offensesunf_1c4
rename V399  offensesunf_2c4
rename V400  offensesunf_3c4
rename V401  offensesunf_4c4
rename V402  offensesunf_5c4
rename V403  offensesunf_6c4
rename V404  offensesunf_7c4
rename V405  offensesunf_8c4
rename V406  offensesunf_9c4
rename V407  offensesunf_10c4
rename V408  offensesunf_11c4
rename V409  offensesunf_12c4
rename V410  offensesunf_13c4
rename V411  offensesunf_14c4
rename V412  offensesunf_15c4
rename V413  offensesunf_16c4
rename V414  offensesunf_17c4
rename V415  offensesunf_18c4
rename V416  offensesunf_19c4
rename V417  offensesunf_20c4
rename V418  offensesunf_21c4
rename V419  offensesunf_22c4
rename V420  offensesunf_23c4
rename V421  offensesunf_24c4
rename V422  offensesunf_25c4
rename V423  offensesunf_26c4
rename V424  offenses_1c4
rename V425  offenses_2c4
rename V426  offenses_3c4
rename V427  offenses_4c4
rename V428  offenses_5c4
rename V429  offenses_6c4
rename V430  offenses_7c4
rename V431  offenses_8c4
rename V432  offenses_9c4
rename V433  offenses_10c4
rename V434  offenses_11c4
rename V435  offenses_12c4
rename V436  offenses_13c4
rename V437  offenses_14c4
rename V438  offenses_15c4
rename V439  offenses_16c4
rename V440  offenses_17c4
rename V441  offenses_18c4
rename V442  offenses_19c4
rename V443  offenses_20c4
rename V444  offenses_21c4
rename V445  offenses_22c4
rename V446  offenses_23c4
rename V447  offenses_24c4
rename V448  offenses_25c4
rename V449  offenses_26c4
rename V450  clearances_1c4
rename V451  clearances_2c4
rename V452  clearances_3c4
rename V453  clearances_4c4
rename V454  clearances_5c4
rename V455  clearances_6c4
rename V456  clearances_7c4
rename V457  clearances_8c4
rename V458  clearances_9c4
rename V459  clearances_10c4
rename V460  clearances_11c4
rename V461  clearances_12c4
rename V462  clearances_13c4
rename V463  clearances_14c4
rename V464  clearances_15c4
rename V465  clearances_16c4
rename V466  clearances_17c4
rename V467  clearances_18c4
rename V468  clearances_19c4
rename V469  clearances_20c4
rename V470  clearances_21c4
rename V471  clearances_22c4
rename V472  clearances_23c4
rename V473  clearances_24c4
rename V474  clearances_25c4
rename V475  clearances_26c4
rename V476  clearancesu18_1c4
rename V477  clearancesu18_2c4
rename V478  clearancesu18_3c4
rename V479  clearancesu18_4c4
rename V480  clearancesu18_5c4
rename V481  clearancesu18_6c4
rename V482  clearancesu18_7c4
rename V483  clearancesu18_8c4
rename V484  clearancesu18_9c4
rename V485  clearancesu18_10c4
rename V486  clearancesu18_11c4
rename V487  clearancesu18_12c4
rename V488  clearancesu18_13c4
rename V489  clearancesu18_14c4
rename V490  clearancesu18_15c4
rename V491  clearancesu18_16c4
rename V492  clearancesu18_17c4
rename V493  clearancesu18_18c4
rename V494  clearancesu18_19c4
rename V495  clearancesu18_20c4
rename V496  clearancesu18_21c4
rename V497  clearancesu18_22c4
rename V498  clearancesu18_23c4
rename V499  clearancesu18_24c4
rename V500  clearancesu18_25c4
rename V501  clearancesu18_26c4
rename V502  felonious4
rename V503  accidental4
rename V504  officerass4
rename V505  monthincl5
rename V506  datelastup5
rename V507  card0type5
rename V508  card1type5
rename V509  card2type5
rename V510  card3type5
rename V511  card4type5
rename V512 card0pt5
rename V513 card1pt5
rename V514 card2pt5
rename V515 card3pt5
rename V516  offensesunf_1c5
rename V517  offensesunf_2c5
rename V518  offensesunf_3c5
rename V519  offensesunf_4c5
rename V520  offensesunf_5c5
rename V521  offensesunf_6c5
rename V522  offensesunf_7c5
rename V523  offensesunf_8c5
rename V524  offensesunf_9c5
rename V525  offensesunf_10c5
rename V526  offensesunf_11c5
rename V527  offensesunf_12c5
rename V528  offensesunf_13c5
rename V529  offensesunf_14c5
rename V530  offensesunf_15c5
rename V531  offensesunf_16c5
rename V532  offensesunf_17c5
rename V533  offensesunf_18c5
rename V534  offensesunf_19c5
rename V535  offensesunf_20c5
rename V536  offensesunf_21c5
rename V537  offensesunf_22c5
rename V538  offensesunf_23c5
rename V539  offensesunf_24c5
rename V540  offensesunf_25c5
rename V541  offensesunf_26c5
rename V542  offenses_1c5
rename V543  offenses_2c5
rename V544  offenses_3c5
rename V545  offenses_4c5
rename V546  offenses_5c5
rename V547  offenses_6c5
rename V548  offenses_7c5
rename V549  offenses_8c5
rename V550  offenses_9c5
rename V551  offenses_10c5
rename V552  offenses_11c5
rename V553  offenses_12c5
rename V554  offenses_13c5
rename V555  offenses_14c5
rename V556  offenses_15c5
rename V557  offenses_16c5
rename V558  offenses_17c5
rename V559  offenses_18c5
rename V560  offenses_19c5
rename V561  offenses_20c5
rename V562  offenses_21c5
rename V563  offenses_22c5
rename V564  offenses_23c5
rename V565  offenses_24c5
rename V566  offenses_25c5
rename V567  offenses_26c5
rename V568  clearances_1c5
rename V569  clearances_2c5
rename V570  clearances_3c5
rename V571  clearances_4c5
rename V572  clearances_5c5
rename V573  clearances_6c5
rename V574  clearances_7c5
rename V575  clearances_8c5
rename V576  clearances_9c5
rename V577  clearances_10c5
rename V578  clearances_11c5
rename V579  clearances_12c5
rename V580  clearances_13c5
rename V581  clearances_14c5
rename V582  clearances_15c5
rename V583  clearances_16c5
rename V584  clearances_17c5
rename V585  clearances_18c5
rename V586  clearances_19c5
rename V587  clearances_20c5
rename V588  clearances_21c5
rename V589  clearances_22c5
rename V590  clearances_23c5
rename V591  clearances_24c5
rename V592  clearances_25c5
rename V593  clearances_26c5
rename V594  clearancesu18_1c5
rename V595  clearancesu18_2c5
rename V596  clearancesu18_3c5
rename V597  clearancesu18_4c5
rename V598  clearancesu18_5c5
rename V599  clearancesu18_6c5
rename V600  clearancesu18_7c5
rename V601  clearancesu18_8c5
rename V602  clearancesu18_9c5
rename V603  clearancesu18_10c5
rename V604  clearancesu18_11c5
rename V605  clearancesu18_12c5
rename V606  clearancesu18_13c5
rename V607  clearancesu18_14c5
rename V608  clearancesu18_15c5
rename V609  clearancesu18_16c5
rename V610  clearancesu18_17c5
rename V611  clearancesu18_18c5
rename V612  clearancesu18_19c5
rename V613  clearancesu18_20c5
rename V614  clearancesu18_21c5
rename V615  clearancesu18_22c5
rename V616  clearancesu18_23c5
rename V617  clearancesu18_24c5
rename V618  clearancesu18_25c5
rename V619  clearancesu18_26c5
rename V620  felonious5
rename V621  accidental5
rename V622  officerass5
rename V623  monthincl6
rename V624  datelastup6
rename V625  card0type6
rename V626  card1type6
rename V627  card2type6
rename V628  card3type6
rename V629  card4type6
rename V630 card0pt6
rename V631 card1pt6
rename V632 card2pt6
rename V633 card3pt6
rename V634  offensesunf_1c6
rename V635  offensesunf_2c6
rename V636  offensesunf_3c6
rename V637  offensesunf_4c6
rename V638  offensesunf_5c6
rename V639  offensesunf_6c6
rename V640  offensesunf_7c6
rename V641  offensesunf_8c6
rename V642  offensesunf_9c6
rename V643  offensesunf_10c6
rename V644  offensesunf_11c6
rename V645  offensesunf_12c6
rename V646  offensesunf_13c6
rename V647  offensesunf_14c6
rename V648  offensesunf_15c6
rename V649  offensesunf_16c6
rename V650  offensesunf_17c6
rename V651  offensesunf_18c6
rename V652  offensesunf_19c6
rename V653  offensesunf_20c6
rename V654  offensesunf_21c6
rename V655  offensesunf_22c6
rename V656  offensesunf_23c6
rename V657  offensesunf_24c6
rename V658  offensesunf_25c6
rename V659  offensesunf_26c6
rename V660  offenses_1c6
rename V661  offenses_2c6
rename V662  offenses_3c6
rename V663  offenses_4c6
rename V664  offenses_5c6
rename V665  offenses_6c6
rename V666  offenses_7c6
rename V667  offenses_8c6
rename V668  offenses_9c6
rename V669  offenses_10c6
rename V670  offenses_11c6
rename V671  offenses_12c6
rename V672  offenses_13c6
rename V673  offenses_14c6
rename V674  offenses_15c6
rename V675  offenses_16c6
rename V676  offenses_17c6
rename V677  offenses_18c6
rename V678  offenses_19c6
rename V679  offenses_20c6
rename V680  offenses_21c6
rename V681  offenses_22c6
rename V682  offenses_23c6
rename V683  offenses_24c6
rename V684  offenses_25c6
rename V685  offenses_26c6
rename V686  clearances_1c6
rename V687  clearances_2c6
rename V688  clearances_3c6
rename V689  clearances_4c6
rename V690  clearances_5c6
rename V691  clearances_6c6
rename V692  clearances_7c6
rename V693  clearances_8c6
rename V694  clearances_9c6
rename V695  clearances_10c6
rename V696  clearances_11c6
rename V697  clearances_12c6
rename V698  clearances_13c6
rename V699  clearances_14c6
rename V700  clearances_15c6
rename V701  clearances_16c6
rename V702  clearances_17c6
rename V703  clearances_18c6
rename V704  clearances_19c6
rename V705  clearances_20c6
rename V706  clearances_21c6
rename V707  clearances_22c6
rename V708  clearances_23c6
rename V709  clearances_24c6
rename V710  clearances_25c6
rename V711  clearances_26c6
rename V712  clearancesu18_1c6
rename V713  clearancesu18_2c6
rename V714  clearancesu18_3c6
rename V715  clearancesu18_4c6
rename V716  clearancesu18_5c6
rename V717  clearancesu18_6c6
rename V718  clearancesu18_7c6
rename V719  clearancesu18_8c6
rename V720  clearancesu18_9c6
rename V721  clearancesu18_10c6
rename V722  clearancesu18_11c6
rename V723  clearancesu18_12c6
rename V724  clearancesu18_13c6
rename V725  clearancesu18_14c6
rename V726  clearancesu18_15c6
rename V727  clearancesu18_16c6
rename V728  clearancesu18_17c6
rename V729  clearancesu18_18c6
rename V730  clearancesu18_19c6
rename V731  clearancesu18_20c6
rename V732  clearancesu18_21c6
rename V733  clearancesu18_22c6
rename V734  clearancesu18_23c6
rename V735  clearancesu18_24c6
rename V736  clearancesu18_25c6
rename V737  clearancesu18_26c6
rename V738  felonious6
rename V739  accidental6
rename V740  officerass6
rename V741  monthincl7
rename V742  datelastup7
rename V743  card0type7
rename V744  card1type7
rename V745  card2type7
rename V746  card3type7
rename V747  card4type7
rename V748 card0pt7
rename V749 card1pt7
rename V750 card2pt7
rename V751 card3pt7
rename V752  offensesunf_1c7
rename V753  offensesunf_2c7
rename V754  offensesunf_3c7
rename V755  offensesunf_4c7
rename V756  offensesunf_5c7
rename V757  offensesunf_6c7
rename V758  offensesunf_7c7
rename V759  offensesunf_8c7
rename V760  offensesunf_9c7
rename V761  offensesunf_10c7
rename V762  offensesunf_11c7
rename V763  offensesunf_12c7
rename V764  offensesunf_13c7
rename V765  offensesunf_14c7
rename V766  offensesunf_15c7
rename V767  offensesunf_16c7
rename V768  offensesunf_17c7
rename V769  offensesunf_18c7
rename V770  offensesunf_19c7
rename V771  offensesunf_20c7
rename V772  offensesunf_21c7
rename V773  offensesunf_22c7
rename V774  offensesunf_23c7
rename V775  offensesunf_24c7
rename V776  offensesunf_25c7
rename V777  offensesunf_26c7
rename V778  offenses_1c7
rename V779  offenses_2c7
rename V780  offenses_3c7
rename V781  offenses_4c7
rename V782  offenses_5c7
rename V783  offenses_6c7
rename V784  offenses_7c7
rename V785  offenses_8c7
rename V786  offenses_9c7
rename V787  offenses_10c7
rename V788  offenses_11c7
rename V789  offenses_12c7
rename V790  offenses_13c7
rename V791  offenses_14c7
rename V792  offenses_15c7
rename V793  offenses_16c7
rename V794  offenses_17c7
rename V795  offenses_18c7
rename V796  offenses_19c7
rename V797  offenses_20c7
rename V798  offenses_21c7
rename V799  offenses_22c7
rename V800  offenses_23c7
rename V801  offenses_24c7
rename V802  offenses_25c7
rename V803  offenses_26c7
rename V804  clearances_1c7
rename V805  clearances_2c7
rename V806  clearances_3c7
rename V807  clearances_4c7
rename V808  clearances_5c7
rename V809  clearances_6c7
rename V810  clearances_7c7
rename V811  clearances_8c7
rename V812  clearances_9c7
rename V813  clearances_10c7
rename V814  clearances_11c7
rename V815  clearances_12c7
rename V816  clearances_13c7
rename V817  clearances_14c7
rename V818  clearances_15c7
rename V819  clearances_16c7
rename V820  clearances_17c7
rename V821  clearances_18c7
rename V822  clearances_19c7
rename V823  clearances_20c7
rename V824  clearances_21c7
rename V825  clearances_22c7
rename V826  clearances_23c7
rename V827  clearances_24c7
rename V828  clearances_25c7
rename V829  clearances_26c7
rename V830  clearancesu18_1c7
rename V831  clearancesu18_2c7
rename V832  clearancesu18_3c7
rename V833  clearancesu18_4c7
rename V834  clearancesu18_5c7
rename V835  clearancesu18_6c7
rename V836  clearancesu18_7c7
rename V837  clearancesu18_8c7
rename V838  clearancesu18_9c7
rename V839  clearancesu18_10c7
rename V840  clearancesu18_11c7
rename V841  clearancesu18_12c7
rename V842  clearancesu18_13c7
rename V843  clearancesu18_14c7
rename V844  clearancesu18_15c7
rename V845  clearancesu18_16c7
rename V846  clearancesu18_17c7
rename V847  clearancesu18_18c7
rename V848  clearancesu18_19c7
rename V849  clearancesu18_20c7
rename V850  clearancesu18_21c7
rename V851  clearancesu18_22c7
rename V852  clearancesu18_23c7
rename V853  clearancesu18_24c7
rename V854  clearancesu18_25c7
rename V855  clearancesu18_26c7
rename V856  felonious7
rename V857  accidental7
rename V858  officerass7
rename V859  monthincl8
rename V860  datelastup8
rename V861  card0type8
rename V862  card1type8
rename V863  card2type8
rename V864  card3type8
rename V865  card4type8
rename V866 card0pt8
rename V867 card1pt8
rename V868 card2pt8
rename V869 card3pt8
rename V870  offensesunf_1c8
rename V871  offensesunf_2c8
rename V872  offensesunf_3c8
rename V873  offensesunf_4c8
rename V874  offensesunf_5c8
rename V875  offensesunf_6c8
rename V876  offensesunf_7c8
rename V877  offensesunf_8c8
rename V878  offensesunf_9c8
rename V879  offensesunf_10c8
rename V880  offensesunf_11c8
rename V881  offensesunf_12c8
rename V882  offensesunf_13c8
rename V883  offensesunf_14c8
rename V884  offensesunf_15c8
rename V885  offensesunf_16c8
rename V886  offensesunf_17c8
rename V887  offensesunf_18c8
rename V888  offensesunf_19c8
rename V889  offensesunf_20c8
rename V890  offensesunf_21c8
rename V891  offensesunf_22c8
rename V892  offensesunf_23c8
rename V893  offensesunf_24c8
rename V894  offensesunf_25c8
rename V895  offensesunf_26c8
rename V896  offenses_1c8
rename V897  offenses_2c8
rename V898  offenses_3c8
rename V899  offenses_4c8
rename V900  offenses_5c8
rename V901  offenses_6c8
rename V902  offenses_7c8
rename V903  offenses_8c8
rename V904  offenses_9c8
rename V905  offenses_10c8
rename V906  offenses_11c8
rename V907  offenses_12c8
rename V908  offenses_13c8
rename V909  offenses_14c8
rename V910  offenses_15c8
rename V911  offenses_16c8
rename V912  offenses_17c8
rename V913  offenses_18c8
rename V914  offenses_19c8
rename V915  offenses_20c8
rename V916  offenses_21c8
rename V917  offenses_22c8
rename V918  offenses_23c8
rename V919  offenses_24c8
rename V920  offenses_25c8
rename V921  offenses_26c8
rename V922  clearances_1c8
rename V923  clearances_2c8
rename V924  clearances_3c8
rename V925  clearances_4c8
rename V926  clearances_5c8
rename V927  clearances_6c8
rename V928  clearances_7c8
rename V929  clearances_8c8
rename V930  clearances_9c8
rename V931  clearances_10c8
rename V932  clearances_11c8
rename V933  clearances_12c8
rename V934  clearances_13c8
rename V935  clearances_14c8
rename V936  clearances_15c8
rename V937  clearances_16c8
rename V938  clearances_17c8
rename V939  clearances_18c8
rename V940  clearances_19c8
rename V941  clearances_20c8
rename V942  clearances_21c8
rename V943  clearances_22c8
rename V944  clearances_23c8
rename V945  clearances_24c8
rename V946  clearances_25c8
rename V947  clearances_26c8
rename V948  clearancesu18_1c8
rename V949  clearancesu18_2c8
rename V950  clearancesu18_3c8
rename V951  clearancesu18_4c8
rename V952  clearancesu18_5c8
rename V953  clearancesu18_6c8
rename V954  clearancesu18_7c8
rename V955  clearancesu18_8c8
rename V956  clearancesu18_9c8
rename V957  clearancesu18_10c8
rename V958  clearancesu18_11c8
rename V959  clearancesu18_12c8
rename V960  clearancesu18_13c8
rename V961  clearancesu18_14c8
rename V962  clearancesu18_15c8
rename V963  clearancesu18_16c8
rename V964  clearancesu18_17c8
rename V965  clearancesu18_18c8
rename V966  clearancesu18_19c8
rename V967  clearancesu18_20c8
rename V968  clearancesu18_21c8
rename V969  clearancesu18_22c8
rename V970  clearancesu18_23c8
rename V971  clearancesu18_24c8
rename V972  clearancesu18_25c8
rename V973  clearancesu18_26c8
rename V974  felonious8
rename V975  accidental8
rename V976  officerass8
rename V977  monthincl9
rename V978  datelastup9
rename V979  card0type9
rename V980  card1type9
rename V981  card2type9
rename V982  card3type9
rename V983  card4type9
rename V984 card0pt9
rename V985 card1pt9
rename V986 card2pt9
rename V987 card3pt9
rename V988  offensesunf_1c9
rename V989  offensesunf_2c9
rename V990  offensesunf_3c9
rename V991  offensesunf_4c9
rename V992  offensesunf_5c9
rename V993  offensesunf_6c9
rename V994  offensesunf_7c9
rename V995  offensesunf_8c9
rename V996  offensesunf_9c9
rename V997  offensesunf_10c9
rename V998  offensesunf_11c9
rename V999  offensesunf_12c9
rename V1000  offensesunf_13c9
rename V1001  offensesunf_14c9
rename V1002  offensesunf_15c9
rename V1003  offensesunf_16c9
rename V1004  offensesunf_17c9
rename V1005  offensesunf_18c9
rename V1006  offensesunf_19c9
rename V1007  offensesunf_20c9
rename V1008  offensesunf_21c9
rename V1009  offensesunf_22c9
rename V1010  offensesunf_23c9
rename V1011  offensesunf_24c9
rename V1012  offensesunf_25c9
rename V1013  offensesunf_26c9
rename V1014  offenses_1c9
rename V1015  offenses_2c9
rename V1016  offenses_3c9
rename V1017  offenses_4c9
rename V1018  offenses_5c9
rename V1019  offenses_6c9
rename V1020  offenses_7c9
rename V1021  offenses_8c9
rename V1022  offenses_9c9
rename V1023  offenses_10c9
rename V1024  offenses_11c9
rename V1025  offenses_12c9
rename V1026  offenses_13c9
rename V1027  offenses_14c9
rename V1028  offenses_15c9
rename V1029  offenses_16c9
rename V1030  offenses_17c9
rename V1031  offenses_18c9
rename V1032  offenses_19c9
rename V1033  offenses_20c9
rename V1034  offenses_21c9
rename V1035  offenses_22c9
rename V1036  offenses_23c9
rename V1037  offenses_24c9
rename V1038  offenses_25c9
rename V1039  offenses_26c9
rename V1040  clearances_1c9
rename V1041  clearances_2c9
rename V1042  clearances_3c9
rename V1043  clearances_4c9
rename V1044  clearances_5c9
rename V1045  clearances_6c9
rename V1046  clearances_7c9
rename V1047  clearances_8c9
rename V1048  clearances_9c9
rename V1049  clearances_10c9
rename V1050  clearances_11c9
rename V1051  clearances_12c9
rename V1052  clearances_13c9
rename V1053  clearances_14c9
rename V1054  clearances_15c9
rename V1055  clearances_16c9
rename V1056  clearances_17c9
rename V1057  clearances_18c9
rename V1058  clearances_19c9
rename V1059  clearances_20c9
rename V1060  clearances_21c9
rename V1061  clearances_22c9
rename V1062  clearances_23c9
rename V1063  clearances_24c9
rename V1064  clearances_25c9
rename V1065  clearances_26c9
rename V1066  clearancesu18_1c9
rename V1067  clearancesu18_2c9
rename V1068  clearancesu18_3c9
rename V1069  clearancesu18_4c9
rename V1070  clearancesu18_5c9
rename V1071  clearancesu18_6c9
rename V1072  clearancesu18_7c9
rename V1073  clearancesu18_8c9
rename V1074  clearancesu18_9c9
rename V1075  clearancesu18_10c9
rename V1076  clearancesu18_11c9
rename V1077  clearancesu18_12c9
rename V1078  clearancesu18_13c9
rename V1079  clearancesu18_14c9
rename V1080  clearancesu18_15c9
rename V1081  clearancesu18_16c9
rename V1082  clearancesu18_17c9
rename V1083  clearancesu18_18c9
rename V1084  clearancesu18_19c9
rename V1085  clearancesu18_20c9
rename V1086  clearancesu18_21c9
rename V1087  clearancesu18_22c9
rename V1088  clearancesu18_23c9
rename V1089  clearancesu18_24c9
rename V1090  clearancesu18_25c9
rename V1091  clearancesu18_26c9
rename V1092  felonious9
rename V1093  accidental9
rename V1094  officerass9
rename V1095  monthincl10
rename V1096  datelastup10
rename V1097  card0type10
rename V1098  card1type10
rename V1099  card2type10
rename V1100  card3type10
rename V1101  card4type10
rename V1102 card0pt10
rename V1103 card1pt10
rename V1104 card2pt10
rename V1105 card3pt10
rename V1106  offensesunf_1c10
rename V1107  offensesunf_2c10
rename V1108  offensesunf_3c10
rename V1109  offensesunf_4c10
rename V1110  offensesunf_5c10
rename V1111  offensesunf_6c10
rename V1112  offensesunf_7c10
rename V1113  offensesunf_8c10
rename V1114  offensesunf_9c10
rename V1115  offensesunf_10c10
rename V1116  offensesunf_11c10
rename V1117  offensesunf_12c10
rename V1118  offensesunf_13c10
rename V1119  offensesunf_14c10
rename V1120  offensesunf_15c10
rename V1121  offensesunf_16c10
rename V1122  offensesunf_17c10
rename V1123  offensesunf_18c10
rename V1124  offensesunf_19c10
rename V1125  offensesunf_20c10
rename V1126  offensesunf_21c10
rename V1127  offensesunf_22c10
rename V1128  offensesunf_23c10
rename V1129  offensesunf_24c10
rename V1130  offensesunf_25c10
rename V1131  offensesunf_26c10
rename V1132  offenses_1c10
rename V1133  offenses_2c10
rename V1134  offenses_3c10
rename V1135  offenses_4c10
rename V1136  offenses_5c10
rename V1137  offenses_6c10
rename V1138  offenses_7c10
rename V1139  offenses_8c10
rename V1140  offenses_9c10
rename V1141  offenses_10c10
rename V1142  offenses_11c10
rename V1143  offenses_12c10
rename V1144  offenses_13c10
rename V1145  offenses_14c10
rename V1146  offenses_15c10
rename V1147  offenses_16c10
rename V1148  offenses_17c10
rename V1149  offenses_18c10
rename V1150  offenses_19c10
rename V1151  offenses_20c10
rename V1152  offenses_21c10
rename V1153  offenses_22c10
rename V1154  offenses_23c10
rename V1155  offenses_24c10
rename V1156  offenses_25c10
rename V1157  offenses_26c10
rename V1158  clearances_1c10
rename V1159  clearances_2c10
rename V1160  clearances_3c10
rename V1161  clearances_4c10
rename V1162  clearances_5c10
rename V1163  clearances_6c10
rename V1164  clearances_7c10
rename V1165  clearances_8c10
rename V1166  clearances_9c10
rename V1167  clearances_10c10
rename V1168  clearances_11c10
rename V1169  clearances_12c10
rename V1170  clearances_13c10
rename V1171  clearances_14c10
rename V1172  clearances_15c10
rename V1173  clearances_16c10
rename V1174  clearances_17c10
rename V1175  clearances_18c10
rename V1176  clearances_19c10
rename V1177  clearances_20c10
rename V1178  clearances_21c10
rename V1179  clearances_22c10
rename V1180  clearances_23c10
rename V1181  clearances_24c10
rename V1182  clearances_25c10
rename V1183  clearances_26c10
rename V1184  clearancesu18_1c10
rename V1185  clearancesu18_2c10
rename V1186  clearancesu18_3c10
rename V1187  clearancesu18_4c10
rename V1188  clearancesu18_5c10
rename V1189  clearancesu18_6c10
rename V1190  clearancesu18_7c10
rename V1191  clearancesu18_8c10
rename V1192  clearancesu18_9c10
rename V1193  clearancesu18_10c10
rename V1194  clearancesu18_11c10
rename V1195  clearancesu18_12c10
rename V1196  clearancesu18_13c10
rename V1197  clearancesu18_14c10
rename V1198  clearancesu18_15c10
rename V1199  clearancesu18_16c10
rename V1200  clearancesu18_17c10
rename V1201  clearancesu18_18c10
rename V1202  clearancesu18_19c10
rename V1203  clearancesu18_20c10
rename V1204  clearancesu18_21c10
rename V1205  clearancesu18_22c10
rename V1206  clearancesu18_23c10
rename V1207  clearancesu18_24c10
rename V1208  clearancesu18_25c10
rename V1209  clearancesu18_26c10
rename V1210  felonious10
rename V1211  accidental10
rename V1212  officerass10
rename V1213  monthincl11
rename V1214  datelastup11
rename V1215  card0type11
rename V1216  card1type11
rename V1217  card2type11
rename V1218  card3type11
rename V1219  card4type11
rename V1220 card0pt11
rename V1221 card1pt11
rename V1222 card2pt11
rename V1223 card3pt11
rename V1224  offensesunf_1c11
rename V1225  offensesunf_2c11
rename V1226  offensesunf_3c11
rename V1227  offensesunf_4c11
rename V1228  offensesunf_5c11
rename V1229  offensesunf_6c11
rename V1230  offensesunf_7c11
rename V1231  offensesunf_8c11
rename V1232  offensesunf_9c11
rename V1233  offensesunf_10c11
rename V1234  offensesunf_11c11
rename V1235  offensesunf_12c11
rename V1236  offensesunf_13c11
rename V1237  offensesunf_14c11
rename V1238  offensesunf_15c11
rename V1239  offensesunf_16c11
rename V1240  offensesunf_17c11
rename V1241  offensesunf_18c11
rename V1242  offensesunf_19c11
rename V1243  offensesunf_20c11
rename V1244  offensesunf_21c11
rename V1245  offensesunf_22c11
rename V1246  offensesunf_23c11
rename V1247  offensesunf_24c11
rename V1248  offensesunf_25c11
rename V1249  offensesunf_26c11
rename V1250  offenses_1c11
rename V1251  offenses_2c11
rename V1252  offenses_3c11
rename V1253  offenses_4c11
rename V1254  offenses_5c11
rename V1255  offenses_6c11
rename V1256  offenses_7c11
rename V1257  offenses_8c11
rename V1258  offenses_9c11
rename V1259  offenses_10c11
rename V1260  offenses_11c11
rename V1261  offenses_12c11
rename V1262  offenses_13c11
rename V1263  offenses_14c11
rename V1264  offenses_15c11
rename V1265  offenses_16c11
rename V1266  offenses_17c11
rename V1267  offenses_18c11
rename V1268  offenses_19c11
rename V1269  offenses_20c11
rename V1270  offenses_21c11
rename V1271  offenses_22c11
rename V1272  offenses_23c11
rename V1273  offenses_24c11
rename V1274  offenses_25c11
rename V1275  offenses_26c11
rename V1276  clearances_1c11
rename V1277  clearances_2c11
rename V1278  clearances_3c11
rename V1279  clearances_4c11
rename V1280  clearances_5c11
rename V1281  clearances_6c11
rename V1282  clearances_7c11
rename V1283  clearances_8c11
rename V1284  clearances_9c11
rename V1285  clearances_10c11
rename V1286  clearances_11c11
rename V1287  clearances_12c11
rename V1288  clearances_13c11
rename V1289  clearances_14c11
rename V1290  clearances_15c11
rename V1291  clearances_16c11
rename V1292  clearances_17c11
rename V1293  clearances_18c11
rename V1294  clearances_19c11
rename V1295  clearances_20c11
rename V1296  clearances_21c11
rename V1297  clearances_22c11
rename V1298  clearances_23c11
rename V1299  clearances_24c11
rename V1300  clearances_25c11
rename V1301  clearances_26c11
rename V1302  clearancesu18_1c11
rename V1303  clearancesu18_2c11
rename V1304  clearancesu18_3c11
rename V1305  clearancesu18_4c11
rename V1306  clearancesu18_5c11
rename V1307  clearancesu18_6c11
rename V1308  clearancesu18_7c11
rename V1309  clearancesu18_8c11
rename V1310  clearancesu18_9c11
rename V1311  clearancesu18_10c11
rename V1312  clearancesu18_11c11
rename V1313  clearancesu18_12c11
rename V1314  clearancesu18_13c11
rename V1315  clearancesu18_14c11
rename V1316  clearancesu18_15c11
rename V1317  clearancesu18_16c11
rename V1318  clearancesu18_17c11
rename V1319  clearancesu18_18c11
rename V1320  clearancesu18_19c11
rename V1321  clearancesu18_20c11
rename V1322  clearancesu18_21c11
rename V1323  clearancesu18_22c11
rename V1324  clearancesu18_23c11
rename V1325  clearancesu18_24c11
rename V1326  clearancesu18_25c11
rename V1327  clearancesu18_26c11
rename V1328  felonious11
rename V1329  accidental11
rename V1330  officerass11
rename V1331  monthincl12
rename V1332  datelastup12
rename V1333  card0type12
rename V1334  card1type12
rename V1335  card2type12
rename V1336  card3type12
rename V1337  card4type12
rename V1338 card0pt12
rename V1339 card1pt12
rename V1340 card2pt12
rename V1341 card3pt12
rename V1342  offensesunf_1c12
rename V1343  offensesunf_2c12
rename V1344  offensesunf_3c12
rename V1345  offensesunf_4c12
rename V1346  offensesunf_5c12
rename V1347  offensesunf_6c12
rename V1348  offensesunf_7c12
rename V1349  offensesunf_8c12
rename V1350  offensesunf_9c12
rename V1351  offensesunf_10c12
rename V1352  offensesunf_11c12
rename V1353  offensesunf_12c12
rename V1354  offensesunf_13c12
rename V1355  offensesunf_14c12
rename V1356  offensesunf_15c12
rename V1357  offensesunf_16c12
rename V1358  offensesunf_17c12
rename V1359  offensesunf_18c12
rename V1360  offensesunf_19c12
rename V1361  offensesunf_20c12
rename V1362  offensesunf_21c12
rename V1363  offensesunf_22c12
rename V1364  offensesunf_23c12
rename V1365  offensesunf_24c12
rename V1366  offensesunf_25c12
rename V1367  offensesunf_26c12
rename V1368  offenses_1c12
rename V1369  offenses_2c12
rename V1370  offenses_3c12
rename V1371  offenses_4c12
rename V1372  offenses_5c12
rename V1373  offenses_6c12
rename V1374  offenses_7c12
rename V1375  offenses_8c12
rename V1376  offenses_9c12
rename V1377  offenses_10c12
rename V1378  offenses_11c12
rename V1379  offenses_12c12
rename V1380  offenses_13c12
rename V1381  offenses_14c12
rename V1382  offenses_15c12
rename V1383  offenses_16c12
rename V1384  offenses_17c12
rename V1385  offenses_18c12
rename V1386  offenses_19c12
rename V1387  offenses_20c12
rename V1388  offenses_21c12
rename V1389  offenses_22c12
rename V1390  offenses_23c12
rename V1391  offenses_24c12
rename V1392  offenses_25c12
rename V1393  offenses_26c12
rename V1394  clearances_1c12
rename V1395  clearances_2c12
rename V1396  clearances_3c12
rename V1397  clearances_4c12
rename V1398  clearances_5c12
rename V1399  clearances_6c12
rename V1400  clearances_7c12
rename V1401  clearances_8c12
rename V1402  clearances_9c12
rename V1403  clearances_10c12
rename V1404  clearances_11c12
rename V1405  clearances_12c12
rename V1406  clearances_13c12
rename V1407  clearances_14c12
rename V1408  clearances_15c12
rename V1409  clearances_16c12
rename V1410  clearances_17c12
rename V1411  clearances_18c12
rename V1412  clearances_19c12
rename V1413  clearances_20c12
rename V1414  clearances_21c12
rename V1415  clearances_22c12
rename V1416  clearances_23c12
rename V1417  clearances_24c12
rename V1418  clearances_25c12
rename V1419  clearances_26c12
rename V1420  clearancesu18_1c12
rename V1421  clearancesu18_2c12
rename V1422  clearancesu18_3c12
rename V1423  clearancesu18_4c12
rename V1424  clearancesu18_5c12
rename V1425  clearancesu18_6c12
rename V1426  clearancesu18_7c12
rename V1427  clearancesu18_8c12
rename V1428  clearancesu18_9c12
rename V1429  clearancesu18_10c12
rename V1430  clearancesu18_11c12
rename V1431  clearancesu18_12c12
rename V1432  clearancesu18_13c12
rename V1433  clearancesu18_14c12
rename V1434  clearancesu18_15c12
rename V1435  clearancesu18_16c12
rename V1436  clearancesu18_17c12
rename V1437  clearancesu18_18c12
rename V1438  clearancesu18_19c12
rename V1439  clearancesu18_20c12
rename V1440  clearancesu18_21c12
rename V1441  clearancesu18_22c12
rename V1442  clearancesu18_23c12
rename V1443  clearancesu18_24c12
rename V1444  clearancesu18_25c12
rename V1445  clearancesu18_26c12
rename V1446  felonious12
rename V1447  accidental12
rename V1448  officerass12

merge 1:1 ori year using rawdata\UCR\ucr_m
drop _merge
save rawdata\UCR\ucr_m, replace
}

///////////////////////////////////////////////////////////////////////////////////////////
///1984-1997///////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////
***1984-1992
infile using "cleaning\ucrdict_1984.dct", clear
merge 1:1 ori year using rawdata\UCR\ucr_m
drop _merge
save rawdata\UCR\ucr_m, replace
forvalues i=1985/1992{
infile using "cleaning\ucrdict_`i'.dct", clear
merge 1:1 ori year using rawdata\UCR\ucr_m
drop _merge
save rawdata\UCR\ucr_m, replace
}
***1993
infile using "cleaning\ucrdict_1993.dct", clear

foreach var of varlist offenses* clearances*{
sum `var'
return list
local max = r(max)
replace `var'=. if (`var'==99999 & `max'==99999) | (`var'==9999 & `max'==9999) | (`var'==999 & `max'==999) | (`var'==99 & `max'==99)
}
merge 1:1 ori year using rawdata\UCR\ucr_m
drop _merge
save rawdata\UCR\ucr_m, replace
***1994-1995
forvalues i=1994/1995{
use "rawdata\UCR\09028-`i'-Data.dta", clear
rename V1  id_code
rename V2  state
rename V3 ori
rename V4 group
rename V5  division
rename V6  year
rename V7 cityseq
rename V8 corecity
rename V9 cover
rename V10  update
rename V11 field
rename V12  nummonth
rename V13  agencycount
rename V14  pop1
rename V15  cty1
rename V16  smsa1
rename V17  pop2
rename V18  cty2
rename V19  smsa2
rename V20  pop3
rename V21  cty3
rename V22  smsa3
rename V23 followup
rename V24 specialmailg
rename V25 specialmaila
rename V26  agency
rename V27 agencyst
rename V28  address1
rename V29  address2
rename V30  address3
rename V31  address4
rename V32  zip
rename V33  monthincl1
rename V34  datelastup1
rename V35  card0type1
rename V36  card1type1
rename V37  card2type1
rename V38  card3type1
rename V39  card4type1
rename V40 card0pt1
rename V41 card1pt1
rename V42 card2pt1
rename V43 card3pt1
rename V44  offensesunf_1c1
rename V45  offensesunf_2c1
rename V46  offensesunf_3c1
rename V47  offensesunf_4c1
rename V48  offensesunf_5c1
rename V49  offensesunf_6c1
rename V50  offensesunf_7c1
rename V51  offensesunf_8c1
rename V52  offensesunf_9c1
rename V53  offensesunf_10c1
rename V54  offensesunf_11c1
rename V55  offensesunf_12c1
rename V56  offensesunf_13c1
rename V57  offensesunf_14c1
rename V58  offensesunf_15c1
rename V59  offensesunf_16c1
rename V60  offensesunf_17c1
rename V61  offensesunf_18c1
rename V62  offensesunf_19c1
rename V63  offensesunf_20c1
rename V64  offensesunf_21c1
rename V65  offensesunf_22c1
rename V66  offensesunf_23c1
rename V67  offensesunf_24c1
rename V68  offensesunf_25c1
rename V69  offensesunf_26c1
rename V70  offenses_1c1
rename V71  offenses_2c1
rename V72  offenses_3c1
rename V73  offenses_4c1
rename V74  offenses_5c1
rename V75  offenses_6c1
rename V76  offenses_7c1
rename V77  offenses_8c1
rename V78  offenses_9c1
rename V79  offenses_10c1
rename V80  offenses_11c1
rename V81  offenses_12c1
rename V82  offenses_13c1
rename V83  offenses_14c1
rename V84  offenses_15c1
rename V85  offenses_16c1
rename V86  offenses_17c1
rename V87  offenses_18c1
rename V88  offenses_19c1
rename V89  offenses_20c1
rename V90  offenses_21c1
rename V91  offenses_22c1
rename V92  offenses_23c1
rename V93  offenses_24c1
rename V94  offenses_25c1
rename V95  offenses_26c1
rename V96  clearances_1c1
rename V97  clearances_2c1
rename V98  clearances_3c1
rename V99  clearances_4c1
rename V100  clearances_5c1
rename V101  clearances_6c1
rename V102  clearances_7c1
rename V103  clearances_8c1
rename V104  clearances_9c1
rename V105  clearances_10c1
rename V106  clearances_11c1
rename V107  clearances_12c1
rename V108  clearances_13c1
rename V109  clearances_14c1
rename V110  clearances_15c1
rename V111  clearances_16c1
rename V112  clearances_17c1
rename V113  clearances_18c1
rename V114  clearances_19c1
rename V115  clearances_20c1
rename V116  clearances_21c1
rename V117  clearances_22c1
rename V118  clearances_23c1
rename V119  clearances_24c1
rename V120  clearances_25c1
rename V121  clearances_26c1
rename V122  clearancesu18_1c1
rename V123  clearancesu18_2c1
rename V124  clearancesu18_3c1
rename V125  clearancesu18_4c1
rename V126  clearancesu18_5c1
rename V127  clearancesu18_6c1
rename V128  clearancesu18_7c1
rename V129  clearancesu18_8c1
rename V130  clearancesu18_9c1
rename V131  clearancesu18_10c1
rename V132  clearancesu18_11c1
rename V133  clearancesu18_12c1
rename V134  clearancesu18_13c1
rename V135  clearancesu18_14c1
rename V136  clearancesu18_15c1
rename V137  clearancesu18_16c1
rename V138  clearancesu18_17c1
rename V139  clearancesu18_18c1
rename V140  clearancesu18_19c1
rename V141  clearancesu18_20c1
rename V142  clearancesu18_21c1
rename V143  clearancesu18_22c1
rename V144  clearancesu18_23c1
rename V145  clearancesu18_24c1
rename V146  clearancesu18_25c1
rename V147  clearancesu18_26c1
rename V148  felonious1
rename V149  accidental1
rename V150  officerass1
rename V151  monthincl2
rename V152  datelastup2
rename V153  card0type2
rename V154  card1type2
rename V155  card2type2
rename V156  card3type2
rename V157  card4type2
rename V158 card0pt2
rename V159 card1pt2
rename V160 card2pt2
rename V161 card3pt2
rename V162  offensesunf_1c2
rename V163  offensesunf_2c2
rename V164  offensesunf_3c2
rename V165  offensesunf_4c2
rename V166  offensesunf_5c2
rename V167  offensesunf_6c2
rename V168  offensesunf_7c2
rename V169  offensesunf_8c2
rename V170  offensesunf_9c2
rename V171  offensesunf_10c2
rename V172  offensesunf_11c2
rename V173  offensesunf_12c2
rename V174  offensesunf_13c2
rename V175  offensesunf_14c2
rename V176  offensesunf_15c2
rename V177  offensesunf_16c2
rename V178  offensesunf_17c2
rename V179  offensesunf_18c2
rename V180  offensesunf_19c2
rename V181  offensesunf_20c2
rename V182  offensesunf_21c2
rename V183  offensesunf_22c2
rename V184  offensesunf_23c2
rename V185  offensesunf_24c2
rename V186  offensesunf_25c2
rename V187  offensesunf_26c2
rename V188  offenses_1c2
rename V189  offenses_2c2
rename V190  offenses_3c2
rename V191  offenses_4c2
rename V192  offenses_5c2
rename V193  offenses_6c2
rename V194  offenses_7c2
rename V195  offenses_8c2
rename V196  offenses_9c2
rename V197  offenses_10c2
rename V198  offenses_11c2
rename V199  offenses_12c2
rename V200  offenses_13c2
rename V201  offenses_14c2
rename V202  offenses_15c2
rename V203  offenses_16c2
rename V204  offenses_17c2
rename V205  offenses_18c2
rename V206  offenses_19c2
rename V207  offenses_20c2
rename V208  offenses_21c2
rename V209  offenses_22c2
rename V210  offenses_23c2
rename V211  offenses_24c2
rename V212  offenses_25c2
rename V213  offenses_26c2
rename V214  clearances_1c2
rename V215  clearances_2c2
rename V216  clearances_3c2
rename V217  clearances_4c2
rename V218  clearances_5c2
rename V219  clearances_6c2
rename V220  clearances_7c2
rename V221  clearances_8c2
rename V222  clearances_9c2
rename V223  clearances_10c2
rename V224  clearances_11c2
rename V225  clearances_12c2
rename V226  clearances_13c2
rename V227  clearances_14c2
rename V228  clearances_15c2
rename V229  clearances_16c2
rename V230  clearances_17c2
rename V231  clearances_18c2
rename V232  clearances_19c2
rename V233  clearances_20c2
rename V234  clearances_21c2
rename V235  clearances_22c2
rename V236  clearances_23c2
rename V237  clearances_24c2
rename V238  clearances_25c2
rename V239  clearances_26c2
rename V240  clearancesu18_1c2
rename V241  clearancesu18_2c2
rename V242  clearancesu18_3c2
rename V243  clearancesu18_4c2
rename V244  clearancesu18_5c2
rename V245  clearancesu18_6c2
rename V246  clearancesu18_7c2
rename V247  clearancesu18_8c2
rename V248  clearancesu18_9c2
rename V249  clearancesu18_10c2
rename V250  clearancesu18_11c2
rename V251  clearancesu18_12c2
rename V252  clearancesu18_13c2
rename V253  clearancesu18_14c2
rename V254  clearancesu18_15c2
rename V255  clearancesu18_16c2
rename V256  clearancesu18_17c2
rename V257  clearancesu18_18c2
rename V258  clearancesu18_19c2
rename V259  clearancesu18_20c2
rename V260  clearancesu18_21c2
rename V261  clearancesu18_22c2
rename V262  clearancesu18_23c2
rename V263  clearancesu18_24c2
rename V264  clearancesu18_25c2
rename V265  clearancesu18_26c2
rename V266  felonious2
rename V267  accidental2
rename V268  officerass2
rename V269  monthincl3
rename V270  datelastup3
rename V271  card0type3
rename V272  card1type3
rename V273  card2type3
rename V274  card3type3
rename V275  card4type3
rename V276 card0pt3
rename V277 card1pt3
rename V278 card2pt3
rename V279 card3pt3
rename V280  offensesunf_1c3
rename V281  offensesunf_2c3
rename V282  offensesunf_3c3
rename V283  offensesunf_4c3
rename V284  offensesunf_5c3
rename V285  offensesunf_6c3
rename V286  offensesunf_7c3
rename V287  offensesunf_8c3
rename V288  offensesunf_9c3
rename V289  offensesunf_10c3
rename V290  offensesunf_11c3
rename V291  offensesunf_12c3
rename V292  offensesunf_13c3
rename V293  offensesunf_14c3
rename V294  offensesunf_15c3
rename V295  offensesunf_16c3
rename V296  offensesunf_17c3
rename V297  offensesunf_18c3
rename V298  offensesunf_19c3
rename V299  offensesunf_20c3
rename V300  offensesunf_21c3
rename V301  offensesunf_22c3
rename V302  offensesunf_23c3
rename V303  offensesunf_24c3
rename V304  offensesunf_25c3
rename V305  offensesunf_26c3
rename V306  offenses_1c3
rename V307  offenses_2c3
rename V308  offenses_3c3
rename V309  offenses_4c3
rename V310  offenses_5c3
rename V311  offenses_6c3
rename V312  offenses_7c3
rename V313  offenses_8c3
rename V314  offenses_9c3
rename V315  offenses_10c3
rename V316  offenses_11c3
rename V317  offenses_12c3
rename V318  offenses_13c3
rename V319  offenses_14c3
rename V320  offenses_15c3
rename V321  offenses_16c3
rename V322  offenses_17c3
rename V323  offenses_18c3
rename V324  offenses_19c3
rename V325  offenses_20c3
rename V326  offenses_21c3
rename V327  offenses_22c3
rename V328  offenses_23c3
rename V329  offenses_24c3
rename V330  offenses_25c3
rename V331  offenses_26c3
rename V332  clearances_1c3
rename V333  clearances_2c3
rename V334  clearances_3c3
rename V335  clearances_4c3
rename V336  clearances_5c3
rename V337  clearances_6c3
rename V338  clearances_7c3
rename V339  clearances_8c3
rename V340  clearances_9c3
rename V341  clearances_10c3
rename V342  clearances_11c3
rename V343  clearances_12c3
rename V344  clearances_13c3
rename V345  clearances_14c3
rename V346  clearances_15c3
rename V347  clearances_16c3
rename V348  clearances_17c3
rename V349  clearances_18c3
rename V350  clearances_19c3
rename V351  clearances_20c3
rename V352  clearances_21c3
rename V353  clearances_22c3
rename V354  clearances_23c3
rename V355  clearances_24c3
rename V356  clearances_25c3
rename V357  clearances_26c3
rename V358  clearancesu18_1c3
rename V359  clearancesu18_2c3
rename V360  clearancesu18_3c3
rename V361  clearancesu18_4c3
rename V362  clearancesu18_5c3
rename V363  clearancesu18_6c3
rename V364  clearancesu18_7c3
rename V365  clearancesu18_8c3
rename V366  clearancesu18_9c3
rename V367  clearancesu18_10c3
rename V368  clearancesu18_11c3
rename V369  clearancesu18_12c3
rename V370  clearancesu18_13c3
rename V371  clearancesu18_14c3
rename V372  clearancesu18_15c3
rename V373  clearancesu18_16c3
rename V374  clearancesu18_17c3
rename V375  clearancesu18_18c3
rename V376  clearancesu18_19c3
rename V377  clearancesu18_20c3
rename V378  clearancesu18_21c3
rename V379  clearancesu18_22c3
rename V380  clearancesu18_23c3
rename V381  clearancesu18_24c3
rename V382  clearancesu18_25c3
rename V383  clearancesu18_26c3
rename V384  felonious3
rename V385  accidental3
rename V386  officerass3
rename V387  monthincl4
rename V388  datelastup4
rename V389  card0type4
rename V390  card1type4
rename V391  card2type4
rename V392  card3type4
rename V393  card4type4
rename V394 card0pt4
rename V395 card1pt4
rename V396 card2pt4
rename V397 card3pt4
rename V398  offensesunf_1c4
rename V399  offensesunf_2c4
rename V400  offensesunf_3c4
rename V401  offensesunf_4c4
rename V402  offensesunf_5c4
rename V403  offensesunf_6c4
rename V404  offensesunf_7c4
rename V405  offensesunf_8c4
rename V406  offensesunf_9c4
rename V407  offensesunf_10c4
rename V408  offensesunf_11c4
rename V409  offensesunf_12c4
rename V410  offensesunf_13c4
rename V411  offensesunf_14c4
rename V412  offensesunf_15c4
rename V413  offensesunf_16c4
rename V414  offensesunf_17c4
rename V415  offensesunf_18c4
rename V416  offensesunf_19c4
rename V417  offensesunf_20c4
rename V418  offensesunf_21c4
rename V419  offensesunf_22c4
rename V420  offensesunf_23c4
rename V421  offensesunf_24c4
rename V422  offensesunf_25c4
rename V423  offensesunf_26c4
rename V424  offenses_1c4
rename V425  offenses_2c4
rename V426  offenses_3c4
rename V427  offenses_4c4
rename V428  offenses_5c4
rename V429  offenses_6c4
rename V430  offenses_7c4
rename V431  offenses_8c4
rename V432  offenses_9c4
rename V433  offenses_10c4
rename V434  offenses_11c4
rename V435  offenses_12c4
rename V436  offenses_13c4
rename V437  offenses_14c4
rename V438  offenses_15c4
rename V439  offenses_16c4
rename V440  offenses_17c4
rename V441  offenses_18c4
rename V442  offenses_19c4
rename V443  offenses_20c4
rename V444  offenses_21c4
rename V445  offenses_22c4
rename V446  offenses_23c4
rename V447  offenses_24c4
rename V448  offenses_25c4
rename V449  offenses_26c4
rename V450  clearances_1c4
rename V451  clearances_2c4
rename V452  clearances_3c4
rename V453  clearances_4c4
rename V454  clearances_5c4
rename V455  clearances_6c4
rename V456  clearances_7c4
rename V457  clearances_8c4
rename V458  clearances_9c4
rename V459  clearances_10c4
rename V460  clearances_11c4
rename V461  clearances_12c4
rename V462  clearances_13c4
rename V463  clearances_14c4
rename V464  clearances_15c4
rename V465  clearances_16c4
rename V466  clearances_17c4
rename V467  clearances_18c4
rename V468  clearances_19c4
rename V469  clearances_20c4
rename V470  clearances_21c4
rename V471  clearances_22c4
rename V472  clearances_23c4
rename V473  clearances_24c4
rename V474  clearances_25c4
rename V475  clearances_26c4
rename V476  clearancesu18_1c4
rename V477  clearancesu18_2c4
rename V478  clearancesu18_3c4
rename V479  clearancesu18_4c4
rename V480  clearancesu18_5c4
rename V481  clearancesu18_6c4
rename V482  clearancesu18_7c4
rename V483  clearancesu18_8c4
rename V484  clearancesu18_9c4
rename V485  clearancesu18_10c4
rename V486  clearancesu18_11c4
rename V487  clearancesu18_12c4
rename V488  clearancesu18_13c4
rename V489  clearancesu18_14c4
rename V490  clearancesu18_15c4
rename V491  clearancesu18_16c4
rename V492  clearancesu18_17c4
rename V493  clearancesu18_18c4
rename V494  clearancesu18_19c4
rename V495  clearancesu18_20c4
rename V496  clearancesu18_21c4
rename V497  clearancesu18_22c4
rename V498  clearancesu18_23c4
rename V499  clearancesu18_24c4
rename V500  clearancesu18_25c4
rename V501  clearancesu18_26c4
rename V502  felonious4
rename V503  accidental4
rename V504  officerass4
rename V505  monthincl5
rename V506  datelastup5
rename V507  card0type5
rename V508  card1type5
rename V509  card2type5
rename V510  card3type5
rename V511  card4type5
rename V512 card0pt5
rename V513 card1pt5
rename V514 card2pt5
rename V515 card3pt5
rename V516  offensesunf_1c5
rename V517  offensesunf_2c5
rename V518  offensesunf_3c5
rename V519  offensesunf_4c5
rename V520  offensesunf_5c5
rename V521  offensesunf_6c5
rename V522  offensesunf_7c5
rename V523  offensesunf_8c5
rename V524  offensesunf_9c5
rename V525  offensesunf_10c5
rename V526  offensesunf_11c5
rename V527  offensesunf_12c5
rename V528  offensesunf_13c5
rename V529  offensesunf_14c5
rename V530  offensesunf_15c5
rename V531  offensesunf_16c5
rename V532  offensesunf_17c5
rename V533  offensesunf_18c5
rename V534  offensesunf_19c5
rename V535  offensesunf_20c5
rename V536  offensesunf_21c5
rename V537  offensesunf_22c5
rename V538  offensesunf_23c5
rename V539  offensesunf_24c5
rename V540  offensesunf_25c5
rename V541  offensesunf_26c5
rename V542  offenses_1c5
rename V543  offenses_2c5
rename V544  offenses_3c5
rename V545  offenses_4c5
rename V546  offenses_5c5
rename V547  offenses_6c5
rename V548  offenses_7c5
rename V549  offenses_8c5
rename V550  offenses_9c5
rename V551  offenses_10c5
rename V552  offenses_11c5
rename V553  offenses_12c5
rename V554  offenses_13c5
rename V555  offenses_14c5
rename V556  offenses_15c5
rename V557  offenses_16c5
rename V558  offenses_17c5
rename V559  offenses_18c5
rename V560  offenses_19c5
rename V561  offenses_20c5
rename V562  offenses_21c5
rename V563  offenses_22c5
rename V564  offenses_23c5
rename V565  offenses_24c5
rename V566  offenses_25c5
rename V567  offenses_26c5
rename V568  clearances_1c5
rename V569  clearances_2c5
rename V570  clearances_3c5
rename V571  clearances_4c5
rename V572  clearances_5c5
rename V573  clearances_6c5
rename V574  clearances_7c5
rename V575  clearances_8c5
rename V576  clearances_9c5
rename V577  clearances_10c5
rename V578  clearances_11c5
rename V579  clearances_12c5
rename V580  clearances_13c5
rename V581  clearances_14c5
rename V582  clearances_15c5
rename V583  clearances_16c5
rename V584  clearances_17c5
rename V585  clearances_18c5
rename V586  clearances_19c5
rename V587  clearances_20c5
rename V588  clearances_21c5
rename V589  clearances_22c5
rename V590  clearances_23c5
rename V591  clearances_24c5
rename V592  clearances_25c5
rename V593  clearances_26c5
rename V594  clearancesu18_1c5
rename V595  clearancesu18_2c5
rename V596  clearancesu18_3c5
rename V597  clearancesu18_4c5
rename V598  clearancesu18_5c5
rename V599  clearancesu18_6c5
rename V600  clearancesu18_7c5
rename V601  clearancesu18_8c5
rename V602  clearancesu18_9c5
rename V603  clearancesu18_10c5
rename V604  clearancesu18_11c5
rename V605  clearancesu18_12c5
rename V606  clearancesu18_13c5
rename V607  clearancesu18_14c5
rename V608  clearancesu18_15c5
rename V609  clearancesu18_16c5
rename V610  clearancesu18_17c5
rename V611  clearancesu18_18c5
rename V612  clearancesu18_19c5
rename V613  clearancesu18_20c5
rename V614  clearancesu18_21c5
rename V615  clearancesu18_22c5
rename V616  clearancesu18_23c5
rename V617  clearancesu18_24c5
rename V618  clearancesu18_25c5
rename V619  clearancesu18_26c5
rename V620  felonious5
rename V621  accidental5
rename V622  officerass5
rename V623  monthincl6
rename V624  datelastup6
rename V625  card0type6
rename V626  card1type6
rename V627  card2type6
rename V628  card3type6
rename V629  card4type6
rename V630 card0pt6
rename V631 card1pt6
rename V632 card2pt6
rename V633 card3pt6
rename V634  offensesunf_1c6
rename V635  offensesunf_2c6
rename V636  offensesunf_3c6
rename V637  offensesunf_4c6
rename V638  offensesunf_5c6
rename V639  offensesunf_6c6
rename V640  offensesunf_7c6
rename V641  offensesunf_8c6
rename V642  offensesunf_9c6
rename V643  offensesunf_10c6
rename V644  offensesunf_11c6
rename V645  offensesunf_12c6
rename V646  offensesunf_13c6
rename V647  offensesunf_14c6
rename V648  offensesunf_15c6
rename V649  offensesunf_16c6
rename V650  offensesunf_17c6
rename V651  offensesunf_18c6
rename V652  offensesunf_19c6
rename V653  offensesunf_20c6
rename V654  offensesunf_21c6
rename V655  offensesunf_22c6
rename V656  offensesunf_23c6
rename V657  offensesunf_24c6
rename V658  offensesunf_25c6
rename V659  offensesunf_26c6
rename V660  offenses_1c6
rename V661  offenses_2c6
rename V662  offenses_3c6
rename V663  offenses_4c6
rename V664  offenses_5c6
rename V665  offenses_6c6
rename V666  offenses_7c6
rename V667  offenses_8c6
rename V668  offenses_9c6
rename V669  offenses_10c6
rename V670  offenses_11c6
rename V671  offenses_12c6
rename V672  offenses_13c6
rename V673  offenses_14c6
rename V674  offenses_15c6
rename V675  offenses_16c6
rename V676  offenses_17c6
rename V677  offenses_18c6
rename V678  offenses_19c6
rename V679  offenses_20c6
rename V680  offenses_21c6
rename V681  offenses_22c6
rename V682  offenses_23c6
rename V683  offenses_24c6
rename V684  offenses_25c6
rename V685  offenses_26c6
rename V686  clearances_1c6
rename V687  clearances_2c6
rename V688  clearances_3c6
rename V689  clearances_4c6
rename V690  clearances_5c6
rename V691  clearances_6c6
rename V692  clearances_7c6
rename V693  clearances_8c6
rename V694  clearances_9c6
rename V695  clearances_10c6
rename V696  clearances_11c6
rename V697  clearances_12c6
rename V698  clearances_13c6
rename V699  clearances_14c6
rename V700  clearances_15c6
rename V701  clearances_16c6
rename V702  clearances_17c6
rename V703  clearances_18c6
rename V704  clearances_19c6
rename V705  clearances_20c6
rename V706  clearances_21c6
rename V707  clearances_22c6
rename V708  clearances_23c6
rename V709  clearances_24c6
rename V710  clearances_25c6
rename V711  clearances_26c6
rename V712  clearancesu18_1c6
rename V713  clearancesu18_2c6
rename V714  clearancesu18_3c6
rename V715  clearancesu18_4c6
rename V716  clearancesu18_5c6
rename V717  clearancesu18_6c6
rename V718  clearancesu18_7c6
rename V719  clearancesu18_8c6
rename V720  clearancesu18_9c6
rename V721  clearancesu18_10c6
rename V722  clearancesu18_11c6
rename V723  clearancesu18_12c6
rename V724  clearancesu18_13c6
rename V725  clearancesu18_14c6
rename V726  clearancesu18_15c6
rename V727  clearancesu18_16c6
rename V728  clearancesu18_17c6
rename V729  clearancesu18_18c6
rename V730  clearancesu18_19c6
rename V731  clearancesu18_20c6
rename V732  clearancesu18_21c6
rename V733  clearancesu18_22c6
rename V734  clearancesu18_23c6
rename V735  clearancesu18_24c6
rename V736  clearancesu18_25c6
rename V737  clearancesu18_26c6
rename V738  felonious6
rename V739  accidental6
rename V740  officerass6
rename V741  monthincl7
rename V742  datelastup7
rename V743  card0type7
rename V744  card1type7
rename V745  card2type7
rename V746  card3type7
rename V747  card4type7
rename V748 card0pt7
rename V749 card1pt7
rename V750 card2pt7
rename V751 card3pt7
rename V752  offensesunf_1c7
rename V753  offensesunf_2c7
rename V754  offensesunf_3c7
rename V755  offensesunf_4c7
rename V756  offensesunf_5c7
rename V757  offensesunf_6c7
rename V758  offensesunf_7c7
rename V759  offensesunf_8c7
rename V760  offensesunf_9c7
rename V761  offensesunf_10c7
rename V762  offensesunf_11c7
rename V763  offensesunf_12c7
rename V764  offensesunf_13c7
rename V765  offensesunf_14c7
rename V766  offensesunf_15c7
rename V767  offensesunf_16c7
rename V768  offensesunf_17c7
rename V769  offensesunf_18c7
rename V770  offensesunf_19c7
rename V771  offensesunf_20c7
rename V772  offensesunf_21c7
rename V773  offensesunf_22c7
rename V774  offensesunf_23c7
rename V775  offensesunf_24c7
rename V776  offensesunf_25c7
rename V777  offensesunf_26c7
rename V778  offenses_1c7
rename V779  offenses_2c7
rename V780  offenses_3c7
rename V781  offenses_4c7
rename V782  offenses_5c7
rename V783  offenses_6c7
rename V784  offenses_7c7
rename V785  offenses_8c7
rename V786  offenses_9c7
rename V787  offenses_10c7
rename V788  offenses_11c7
rename V789  offenses_12c7
rename V790  offenses_13c7
rename V791  offenses_14c7
rename V792  offenses_15c7
rename V793  offenses_16c7
rename V794  offenses_17c7
rename V795  offenses_18c7
rename V796  offenses_19c7
rename V797  offenses_20c7
rename V798  offenses_21c7
rename V799  offenses_22c7
rename V800  offenses_23c7
rename V801  offenses_24c7
rename V802  offenses_25c7
rename V803  offenses_26c7
rename V804  clearances_1c7
rename V805  clearances_2c7
rename V806  clearances_3c7
rename V807  clearances_4c7
rename V808  clearances_5c7
rename V809  clearances_6c7
rename V810  clearances_7c7
rename V811  clearances_8c7
rename V812  clearances_9c7
rename V813  clearances_10c7
rename V814  clearances_11c7
rename V815  clearances_12c7
rename V816  clearances_13c7
rename V817  clearances_14c7
rename V818  clearances_15c7
rename V819  clearances_16c7
rename V820  clearances_17c7
rename V821  clearances_18c7
rename V822  clearances_19c7
rename V823  clearances_20c7
rename V824  clearances_21c7
rename V825  clearances_22c7
rename V826  clearances_23c7
rename V827  clearances_24c7
rename V828  clearances_25c7
rename V829  clearances_26c7
rename V830  clearancesu18_1c7
rename V831  clearancesu18_2c7
rename V832  clearancesu18_3c7
rename V833  clearancesu18_4c7
rename V834  clearancesu18_5c7
rename V835  clearancesu18_6c7
rename V836  clearancesu18_7c7
rename V837  clearancesu18_8c7
rename V838  clearancesu18_9c7
rename V839  clearancesu18_10c7
rename V840  clearancesu18_11c7
rename V841  clearancesu18_12c7
rename V842  clearancesu18_13c7
rename V843  clearancesu18_14c7
rename V844  clearancesu18_15c7
rename V845  clearancesu18_16c7
rename V846  clearancesu18_17c7
rename V847  clearancesu18_18c7
rename V848  clearancesu18_19c7
rename V849  clearancesu18_20c7
rename V850  clearancesu18_21c7
rename V851  clearancesu18_22c7
rename V852  clearancesu18_23c7
rename V853  clearancesu18_24c7
rename V854  clearancesu18_25c7
rename V855  clearancesu18_26c7
rename V856  felonious7
rename V857  accidental7
rename V858  officerass7
rename V859  monthincl8
rename V860  datelastup8
rename V861  card0type8
rename V862  card1type8
rename V863  card2type8
rename V864  card3type8
rename V865  card4type8
rename V866 card0pt8
rename V867 card1pt8
rename V868 card2pt8
rename V869 card3pt8
rename V870  offensesunf_1c8
rename V871  offensesunf_2c8
rename V872  offensesunf_3c8
rename V873  offensesunf_4c8
rename V874  offensesunf_5c8
rename V875  offensesunf_6c8
rename V876  offensesunf_7c8
rename V877  offensesunf_8c8
rename V878  offensesunf_9c8
rename V879  offensesunf_10c8
rename V880  offensesunf_11c8
rename V881  offensesunf_12c8
rename V882  offensesunf_13c8
rename V883  offensesunf_14c8
rename V884  offensesunf_15c8
rename V885  offensesunf_16c8
rename V886  offensesunf_17c8
rename V887  offensesunf_18c8
rename V888  offensesunf_19c8
rename V889  offensesunf_20c8
rename V890  offensesunf_21c8
rename V891  offensesunf_22c8
rename V892  offensesunf_23c8
rename V893  offensesunf_24c8
rename V894  offensesunf_25c8
rename V895  offensesunf_26c8
rename V896  offenses_1c8
rename V897  offenses_2c8
rename V898  offenses_3c8
rename V899  offenses_4c8
rename V900  offenses_5c8
rename V901  offenses_6c8
rename V902  offenses_7c8
rename V903  offenses_8c8
rename V904  offenses_9c8
rename V905  offenses_10c8
rename V906  offenses_11c8
rename V907  offenses_12c8
rename V908  offenses_13c8
rename V909  offenses_14c8
rename V910  offenses_15c8
rename V911  offenses_16c8
rename V912  offenses_17c8
rename V913  offenses_18c8
rename V914  offenses_19c8
rename V915  offenses_20c8
rename V916  offenses_21c8
rename V917  offenses_22c8
rename V918  offenses_23c8
rename V919  offenses_24c8
rename V920  offenses_25c8
rename V921  offenses_26c8
rename V922  clearances_1c8
rename V923  clearances_2c8
rename V924  clearances_3c8
rename V925  clearances_4c8
rename V926  clearances_5c8
rename V927  clearances_6c8
rename V928  clearances_7c8
rename V929  clearances_8c8
rename V930  clearances_9c8
rename V931  clearances_10c8
rename V932  clearances_11c8
rename V933  clearances_12c8
rename V934  clearances_13c8
rename V935  clearances_14c8
rename V936  clearances_15c8
rename V937  clearances_16c8
rename V938  clearances_17c8
rename V939  clearances_18c8
rename V940  clearances_19c8
rename V941  clearances_20c8
rename V942  clearances_21c8
rename V943  clearances_22c8
rename V944  clearances_23c8
rename V945  clearances_24c8
rename V946  clearances_25c8
rename V947  clearances_26c8
rename V948  clearancesu18_1c8
rename V949  clearancesu18_2c8
rename V950  clearancesu18_3c8
rename V951  clearancesu18_4c8
rename V952  clearancesu18_5c8
rename V953  clearancesu18_6c8
rename V954  clearancesu18_7c8
rename V955  clearancesu18_8c8
rename V956  clearancesu18_9c8
rename V957  clearancesu18_10c8
rename V958  clearancesu18_11c8
rename V959  clearancesu18_12c8
rename V960  clearancesu18_13c8
rename V961  clearancesu18_14c8
rename V962  clearancesu18_15c8
rename V963  clearancesu18_16c8
rename V964  clearancesu18_17c8
rename V965  clearancesu18_18c8
rename V966  clearancesu18_19c8
rename V967  clearancesu18_20c8
rename V968  clearancesu18_21c8
rename V969  clearancesu18_22c8
rename V970  clearancesu18_23c8
rename V971  clearancesu18_24c8
rename V972  clearancesu18_25c8
rename V973  clearancesu18_26c8
rename V974  felonious8
rename V975  accidental8
rename V976  officerass8
rename V977  monthincl9
rename V978  datelastup9
rename V979  card0type9
rename V980  card1type9
rename V981  card2type9
rename V982  card3type9
rename V983  card4type9
rename V984 card0pt9
rename V985 card1pt9
rename V986 card2pt9
rename V987 card3pt9
rename V988  offensesunf_1c9
rename V989  offensesunf_2c9
rename V990  offensesunf_3c9
rename V991  offensesunf_4c9
rename V992  offensesunf_5c9
rename V993  offensesunf_6c9
rename V994  offensesunf_7c9
rename V995  offensesunf_8c9
rename V996  offensesunf_9c9
rename V997  offensesunf_10c9
rename V998  offensesunf_11c9
rename V999  offensesunf_12c9
rename V1000  offensesunf_13c9
rename V1001  offensesunf_14c9
rename V1002  offensesunf_15c9
rename V1003  offensesunf_16c9
rename V1004  offensesunf_17c9
rename V1005  offensesunf_18c9
rename V1006  offensesunf_19c9
rename V1007  offensesunf_20c9
rename V1008  offensesunf_21c9
rename V1009  offensesunf_22c9
rename V1010  offensesunf_23c9
rename V1011  offensesunf_24c9
rename V1012  offensesunf_25c9
rename V1013  offensesunf_26c9
rename V1014  offenses_1c9
rename V1015  offenses_2c9
rename V1016  offenses_3c9
rename V1017  offenses_4c9
rename V1018  offenses_5c9
rename V1019  offenses_6c9
rename V1020  offenses_7c9
rename V1021  offenses_8c9
rename V1022  offenses_9c9
rename V1023  offenses_10c9
rename V1024  offenses_11c9
rename V1025  offenses_12c9
rename V1026  offenses_13c9
rename V1027  offenses_14c9
rename V1028  offenses_15c9
rename V1029  offenses_16c9
rename V1030  offenses_17c9
rename V1031  offenses_18c9
rename V1032  offenses_19c9
rename V1033  offenses_20c9
rename V1034  offenses_21c9
rename V1035  offenses_22c9
rename V1036  offenses_23c9
rename V1037  offenses_24c9
rename V1038  offenses_25c9
rename V1039  offenses_26c9
rename V1040  clearances_1c9
rename V1041  clearances_2c9
rename V1042  clearances_3c9
rename V1043  clearances_4c9
rename V1044  clearances_5c9
rename V1045  clearances_6c9
rename V1046  clearances_7c9
rename V1047  clearances_8c9
rename V1048  clearances_9c9
rename V1049  clearances_10c9
rename V1050  clearances_11c9
rename V1051  clearances_12c9
rename V1052  clearances_13c9
rename V1053  clearances_14c9
rename V1054  clearances_15c9
rename V1055  clearances_16c9
rename V1056  clearances_17c9
rename V1057  clearances_18c9
rename V1058  clearances_19c9
rename V1059  clearances_20c9
rename V1060  clearances_21c9
rename V1061  clearances_22c9
rename V1062  clearances_23c9
rename V1063  clearances_24c9
rename V1064  clearances_25c9
rename V1065  clearances_26c9
rename V1066  clearancesu18_1c9
rename V1067  clearancesu18_2c9
rename V1068  clearancesu18_3c9
rename V1069  clearancesu18_4c9
rename V1070  clearancesu18_5c9
rename V1071  clearancesu18_6c9
rename V1072  clearancesu18_7c9
rename V1073  clearancesu18_8c9
rename V1074  clearancesu18_9c9
rename V1075  clearancesu18_10c9
rename V1076  clearancesu18_11c9
rename V1077  clearancesu18_12c9
rename V1078  clearancesu18_13c9
rename V1079  clearancesu18_14c9
rename V1080  clearancesu18_15c9
rename V1081  clearancesu18_16c9
rename V1082  clearancesu18_17c9
rename V1083  clearancesu18_18c9
rename V1084  clearancesu18_19c9
rename V1085  clearancesu18_20c9
rename V1086  clearancesu18_21c9
rename V1087  clearancesu18_22c9
rename V1088  clearancesu18_23c9
rename V1089  clearancesu18_24c9
rename V1090  clearancesu18_25c9
rename V1091  clearancesu18_26c9
rename V1092  felonious9
rename V1093  accidental9
rename V1094  officerass9
rename V1095  monthincl10
rename V1096  datelastup10
rename V1097  card0type10
rename V1098  card1type10
rename V1099  card2type10
rename V1100  card3type10
rename V1101  card4type10
rename V1102 card0pt10
rename V1103 card1pt10
rename V1104 card2pt10
rename V1105 card3pt10
rename V1106  offensesunf_1c10
rename V1107  offensesunf_2c10
rename V1108  offensesunf_3c10
rename V1109  offensesunf_4c10
rename V1110  offensesunf_5c10
rename V1111  offensesunf_6c10
rename V1112  offensesunf_7c10
rename V1113  offensesunf_8c10
rename V1114  offensesunf_9c10
rename V1115  offensesunf_10c10
rename V1116  offensesunf_11c10
rename V1117  offensesunf_12c10
rename V1118  offensesunf_13c10
rename V1119  offensesunf_14c10
rename V1120  offensesunf_15c10
rename V1121  offensesunf_16c10
rename V1122  offensesunf_17c10
rename V1123  offensesunf_18c10
rename V1124  offensesunf_19c10
rename V1125  offensesunf_20c10
rename V1126  offensesunf_21c10
rename V1127  offensesunf_22c10
rename V1128  offensesunf_23c10
rename V1129  offensesunf_24c10
rename V1130  offensesunf_25c10
rename V1131  offensesunf_26c10
rename V1132  offenses_1c10
rename V1133  offenses_2c10
rename V1134  offenses_3c10
rename V1135  offenses_4c10
rename V1136  offenses_5c10
rename V1137  offenses_6c10
rename V1138  offenses_7c10
rename V1139  offenses_8c10
rename V1140  offenses_9c10
rename V1141  offenses_10c10
rename V1142  offenses_11c10
rename V1143  offenses_12c10
rename V1144  offenses_13c10
rename V1145  offenses_14c10
rename V1146  offenses_15c10
rename V1147  offenses_16c10
rename V1148  offenses_17c10
rename V1149  offenses_18c10
rename V1150  offenses_19c10
rename V1151  offenses_20c10
rename V1152  offenses_21c10
rename V1153  offenses_22c10
rename V1154  offenses_23c10
rename V1155  offenses_24c10
rename V1156  offenses_25c10
rename V1157  offenses_26c10
rename V1158  clearances_1c10
rename V1159  clearances_2c10
rename V1160  clearances_3c10
rename V1161  clearances_4c10
rename V1162  clearances_5c10
rename V1163  clearances_6c10
rename V1164  clearances_7c10
rename V1165  clearances_8c10
rename V1166  clearances_9c10
rename V1167  clearances_10c10
rename V1168  clearances_11c10
rename V1169  clearances_12c10
rename V1170  clearances_13c10
rename V1171  clearances_14c10
rename V1172  clearances_15c10
rename V1173  clearances_16c10
rename V1174  clearances_17c10
rename V1175  clearances_18c10
rename V1176  clearances_19c10
rename V1177  clearances_20c10
rename V1178  clearances_21c10
rename V1179  clearances_22c10
rename V1180  clearances_23c10
rename V1181  clearances_24c10
rename V1182  clearances_25c10
rename V1183  clearances_26c10
rename V1184  clearancesu18_1c10
rename V1185  clearancesu18_2c10
rename V1186  clearancesu18_3c10
rename V1187  clearancesu18_4c10
rename V1188  clearancesu18_5c10
rename V1189  clearancesu18_6c10
rename V1190  clearancesu18_7c10
rename V1191  clearancesu18_8c10
rename V1192  clearancesu18_9c10
rename V1193  clearancesu18_10c10
rename V1194  clearancesu18_11c10
rename V1195  clearancesu18_12c10
rename V1196  clearancesu18_13c10
rename V1197  clearancesu18_14c10
rename V1198  clearancesu18_15c10
rename V1199  clearancesu18_16c10
rename V1200  clearancesu18_17c10
rename V1201  clearancesu18_18c10
rename V1202  clearancesu18_19c10
rename V1203  clearancesu18_20c10
rename V1204  clearancesu18_21c10
rename V1205  clearancesu18_22c10
rename V1206  clearancesu18_23c10
rename V1207  clearancesu18_24c10
rename V1208  clearancesu18_25c10
rename V1209  clearancesu18_26c10
rename V1210  felonious10
rename V1211  accidental10
rename V1212  officerass10
rename V1213  monthincl11
rename V1214  datelastup11
rename V1215  card0type11
rename V1216  card1type11
rename V1217  card2type11
rename V1218  card3type11
rename V1219  card4type11
rename V1220 card0pt11
rename V1221 card1pt11
rename V1222 card2pt11
rename V1223 card3pt11
rename V1224  offensesunf_1c11
rename V1225  offensesunf_2c11
rename V1226  offensesunf_3c11
rename V1227  offensesunf_4c11
rename V1228  offensesunf_5c11
rename V1229  offensesunf_6c11
rename V1230  offensesunf_7c11
rename V1231  offensesunf_8c11
rename V1232  offensesunf_9c11
rename V1233  offensesunf_10c11
rename V1234  offensesunf_11c11
rename V1235  offensesunf_12c11
rename V1236  offensesunf_13c11
rename V1237  offensesunf_14c11
rename V1238  offensesunf_15c11
rename V1239  offensesunf_16c11
rename V1240  offensesunf_17c11
rename V1241  offensesunf_18c11
rename V1242  offensesunf_19c11
rename V1243  offensesunf_20c11
rename V1244  offensesunf_21c11
rename V1245  offensesunf_22c11
rename V1246  offensesunf_23c11
rename V1247  offensesunf_24c11
rename V1248  offensesunf_25c11
rename V1249  offensesunf_26c11
rename V1250  offenses_1c11
rename V1251  offenses_2c11
rename V1252  offenses_3c11
rename V1253  offenses_4c11
rename V1254  offenses_5c11
rename V1255  offenses_6c11
rename V1256  offenses_7c11
rename V1257  offenses_8c11
rename V1258  offenses_9c11
rename V1259  offenses_10c11
rename V1260  offenses_11c11
rename V1261  offenses_12c11
rename V1262  offenses_13c11
rename V1263  offenses_14c11
rename V1264  offenses_15c11
rename V1265  offenses_16c11
rename V1266  offenses_17c11
rename V1267  offenses_18c11
rename V1268  offenses_19c11
rename V1269  offenses_20c11
rename V1270  offenses_21c11
rename V1271  offenses_22c11
rename V1272  offenses_23c11
rename V1273  offenses_24c11
rename V1274  offenses_25c11
rename V1275  offenses_26c11
rename V1276  clearances_1c11
rename V1277  clearances_2c11
rename V1278  clearances_3c11
rename V1279  clearances_4c11
rename V1280  clearances_5c11
rename V1281  clearances_6c11
rename V1282  clearances_7c11
rename V1283  clearances_8c11
rename V1284  clearances_9c11
rename V1285  clearances_10c11
rename V1286  clearances_11c11
rename V1287  clearances_12c11
rename V1288  clearances_13c11
rename V1289  clearances_14c11
rename V1290  clearances_15c11
rename V1291  clearances_16c11
rename V1292  clearances_17c11
rename V1293  clearances_18c11
rename V1294  clearances_19c11
rename V1295  clearances_20c11
rename V1296  clearances_21c11
rename V1297  clearances_22c11
rename V1298  clearances_23c11
rename V1299  clearances_24c11
rename V1300  clearances_25c11
rename V1301  clearances_26c11
rename V1302  clearancesu18_1c11
rename V1303  clearancesu18_2c11
rename V1304  clearancesu18_3c11
rename V1305  clearancesu18_4c11
rename V1306  clearancesu18_5c11
rename V1307  clearancesu18_6c11
rename V1308  clearancesu18_7c11
rename V1309  clearancesu18_8c11
rename V1310  clearancesu18_9c11
rename V1311  clearancesu18_10c11
rename V1312  clearancesu18_11c11
rename V1313  clearancesu18_12c11
rename V1314  clearancesu18_13c11
rename V1315  clearancesu18_14c11
rename V1316  clearancesu18_15c11
rename V1317  clearancesu18_16c11
rename V1318  clearancesu18_17c11
rename V1319  clearancesu18_18c11
rename V1320  clearancesu18_19c11
rename V1321  clearancesu18_20c11
rename V1322  clearancesu18_21c11
rename V1323  clearancesu18_22c11
rename V1324  clearancesu18_23c11
rename V1325  clearancesu18_24c11
rename V1326  clearancesu18_25c11
rename V1327  clearancesu18_26c11
rename V1328  felonious11
rename V1329  accidental11
rename V1330  officerass11
rename V1331  monthincl12
rename V1332  datelastup12
rename V1333  card0type12
rename V1334  card1type12
rename V1335  card2type12
rename V1336  card3type12
rename V1337  card4type12
rename V1338 card0pt12
rename V1339 card1pt12
rename V1340 card2pt12
rename V1341 card3pt12
rename V1342  offensesunf_1c12
rename V1343  offensesunf_2c12
rename V1344  offensesunf_3c12
rename V1345  offensesunf_4c12
rename V1346  offensesunf_5c12
rename V1347  offensesunf_6c12
rename V1348  offensesunf_7c12
rename V1349  offensesunf_8c12
rename V1350  offensesunf_9c12
rename V1351  offensesunf_10c12
rename V1352  offensesunf_11c12
rename V1353  offensesunf_12c12
rename V1354  offensesunf_13c12
rename V1355  offensesunf_14c12
rename V1356  offensesunf_15c12
rename V1357  offensesunf_16c12
rename V1358  offensesunf_17c12
rename V1359  offensesunf_18c12
rename V1360  offensesunf_19c12
rename V1361  offensesunf_20c12
rename V1362  offensesunf_21c12
rename V1363  offensesunf_22c12
rename V1364  offensesunf_23c12
rename V1365  offensesunf_24c12
rename V1366  offensesunf_25c12
rename V1367  offensesunf_26c12
rename V1368  offenses_1c12
rename V1369  offenses_2c12
rename V1370  offenses_3c12
rename V1371  offenses_4c12
rename V1372  offenses_5c12
rename V1373  offenses_6c12
rename V1374  offenses_7c12
rename V1375  offenses_8c12
rename V1376  offenses_9c12
rename V1377  offenses_10c12
rename V1378  offenses_11c12
rename V1379  offenses_12c12
rename V1380  offenses_13c12
rename V1381  offenses_14c12
rename V1382  offenses_15c12
rename V1383  offenses_16c12
rename V1384  offenses_17c12
rename V1385  offenses_18c12
rename V1386  offenses_19c12
rename V1387  offenses_20c12
rename V1388  offenses_21c12
rename V1389  offenses_22c12
rename V1390  offenses_23c12
rename V1391  offenses_24c12
rename V1392  offenses_25c12
rename V1393  offenses_26c12
rename V1394  clearances_1c12
rename V1395  clearances_2c12
rename V1396  clearances_3c12
rename V1397  clearances_4c12
rename V1398  clearances_5c12
rename V1399  clearances_6c12
rename V1400  clearances_7c12
rename V1401  clearances_8c12
rename V1402  clearances_9c12
rename V1403  clearances_10c12
rename V1404  clearances_11c12
rename V1405  clearances_12c12
rename V1406  clearances_13c12
rename V1407  clearances_14c12
rename V1408  clearances_15c12
rename V1409  clearances_16c12
rename V1410  clearances_17c12
rename V1411  clearances_18c12
rename V1412  clearances_19c12
rename V1413  clearances_20c12
rename V1414  clearances_21c12
rename V1415  clearances_22c12
rename V1416  clearances_23c12
rename V1417  clearances_24c12
rename V1418  clearances_25c12
rename V1419  clearances_26c12
rename V1420  clearancesu18_1c12
rename V1421  clearancesu18_2c12
rename V1422  clearancesu18_3c12
rename V1423  clearancesu18_4c12
rename V1424  clearancesu18_5c12
rename V1425  clearancesu18_6c12
rename V1426  clearancesu18_7c12
rename V1427  clearancesu18_8c12
rename V1428  clearancesu18_9c12
rename V1429  clearancesu18_10c12
rename V1430  clearancesu18_11c12
rename V1431  clearancesu18_12c12
rename V1432  clearancesu18_13c12
rename V1433  clearancesu18_14c12
rename V1434  clearancesu18_15c12
rename V1435  clearancesu18_16c12
rename V1436  clearancesu18_17c12
rename V1437  clearancesu18_18c12
rename V1438  clearancesu18_19c12
rename V1439  clearancesu18_20c12
rename V1440  clearancesu18_21c12
rename V1441  clearancesu18_22c12
rename V1442  clearancesu18_23c12
rename V1443  clearancesu18_24c12
rename V1444  clearancesu18_25c12
rename V1445  clearancesu18_26c12
rename V1446  felonious12
rename V1447  accidental12
rename V1448  officerass12

merge 1:1 ori year using rawdata\UCR\ucr_m
drop _merge
save rawdata\UCR\ucr_m, replace
}
***1996-1997
forvalues i=1996/1997{
infile using "cleaning\ucrdict_`i'.dct", clear

merge 1:1 ori year using rawdata\UCR\ucr_m
drop _merge
save rawdata\UCR\ucr_m, replace
}
///////////////////////////////////////////////////////////////////////////////////////////
///1998-2014///////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////
forvalues i=1998/2014{
use "rawdata\UCR\f`i'-Data.dta", clear
rename V1  id_code
rename V2  state
rename V3 ori
rename V4 group
rename V5  division
rename V6  year
rename V7 cityseq
rename V8 corecity
rename V9 cover
rename V10  update
rename V11 field
rename V12  nummonth
rename V13  agencycount
rename V14  pop1
rename V15  cty1
rename V16  smsa1
rename V17  pop2
rename V18  cty2
rename V19  smsa2
rename V20  pop3
rename V21  cty3
rename V22  smsa3
rename V23 followup
rename V24 specialmailg
rename V25 specialmaila
rename V26  agency
rename V27 agencyst
rename V28  address1
rename V29  address2
rename V30  address3
rename V31  address4
rename V32  zip
rename V33  monthincl1
rename V34  datelastup1
rename V35  card0type1
rename V36  card1type1
rename V37  card2type1
rename V38  card3type1
rename V39  card4type1
rename V40 card0pt1
rename V41 card1pt1
rename V42 card2pt1
rename V43 card3pt1
rename V44  offensesunf_1c1
rename V45  offensesunf_2c1
rename V46  offensesunf_3c1
rename V47  offensesunf_4c1
rename V48  offensesunf_5c1
rename V49  offensesunf_6c1
rename V50  offensesunf_7c1
rename V51  offensesunf_8c1
rename V52  offensesunf_9c1
rename V53  offensesunf_10c1
rename V54  offensesunf_11c1
rename V55  offensesunf_12c1
rename V56  offensesunf_13c1
rename V57  offensesunf_14c1
rename V58  offensesunf_15c1
rename V59  offensesunf_16c1
rename V60  offensesunf_17c1
rename V61  offensesunf_18c1
rename V62  offensesunf_19c1
rename V63  offensesunf_20c1
rename V64  offensesunf_21c1
rename V65  offensesunf_22c1
rename V66  offensesunf_23c1
rename V67  offensesunf_24c1
rename V68  offensesunf_25c1
rename V69  offensesunf_26c1
rename V70  offenses_1c1
rename V71  offenses_2c1
rename V72  offenses_3c1
rename V73  offenses_4c1
rename V74  offenses_5c1
rename V75  offenses_6c1
rename V76  offenses_7c1
rename V77  offenses_8c1
rename V78  offenses_9c1
rename V79  offenses_10c1
rename V80  offenses_11c1
rename V81  offenses_12c1
rename V82  offenses_13c1
rename V83  offenses_14c1
rename V84  offenses_15c1
rename V85  offenses_16c1
rename V86  offenses_17c1
rename V87  offenses_18c1
rename V88  offenses_19c1
rename V89  offenses_20c1
rename V90  offenses_21c1
rename V91  offenses_22c1
rename V92  offenses_23c1
rename V93  offenses_24c1
rename V94  offenses_25c1
rename V95  offenses_26c1
rename V96  clearances_1c1
rename V97  clearances_2c1
rename V98  clearances_3c1
rename V99  clearances_4c1
rename V100  clearances_5c1
rename V101  clearances_6c1
rename V102  clearances_7c1
rename V103  clearances_8c1
rename V104  clearances_9c1
rename V105  clearances_10c1
rename V106  clearances_11c1
rename V107  clearances_12c1
rename V108  clearances_13c1
rename V109  clearances_14c1
rename V110  clearances_15c1
rename V111  clearances_16c1
rename V112  clearances_17c1
rename V113  clearances_18c1
rename V114  clearances_19c1
rename V115  clearances_20c1
rename V116  clearances_21c1
rename V117  clearances_22c1
rename V118  clearances_23c1
rename V119  clearances_24c1
rename V120  clearances_25c1
rename V121  clearances_26c1
rename V122  clearancesu18_1c1
rename V123  clearancesu18_2c1
rename V124  clearancesu18_3c1
rename V125  clearancesu18_4c1
rename V126  clearancesu18_5c1
rename V127  clearancesu18_6c1
rename V128  clearancesu18_7c1
rename V129  clearancesu18_8c1
rename V130  clearancesu18_9c1
rename V131  clearancesu18_10c1
rename V132  clearancesu18_11c1
rename V133  clearancesu18_12c1
rename V134  clearancesu18_13c1
rename V135  clearancesu18_14c1
rename V136  clearancesu18_15c1
rename V137  clearancesu18_16c1
rename V138  clearancesu18_17c1
rename V139  clearancesu18_18c1
rename V140  clearancesu18_19c1
rename V141  clearancesu18_20c1
rename V142  clearancesu18_21c1
rename V143  clearancesu18_22c1
rename V144  clearancesu18_23c1
rename V145  clearancesu18_24c1
rename V146  clearancesu18_25c1
rename V147  clearancesu18_26c1
rename V148  felonious1
rename V149  accidental1
rename V150  officerass1
rename V151  monthincl2
rename V152  datelastup2
rename V153  card0type2
rename V154  card1type2
rename V155  card2type2
rename V156  card3type2
rename V157  card4type2
rename V158 card0pt2
rename V159 card1pt2
rename V160 card2pt2
rename V161 card3pt2
rename V162  offensesunf_1c2
rename V163  offensesunf_2c2
rename V164  offensesunf_3c2
rename V165  offensesunf_4c2
rename V166  offensesunf_5c2
rename V167  offensesunf_6c2
rename V168  offensesunf_7c2
rename V169  offensesunf_8c2
rename V170  offensesunf_9c2
rename V171  offensesunf_10c2
rename V172  offensesunf_11c2
rename V173  offensesunf_12c2
rename V174  offensesunf_13c2
rename V175  offensesunf_14c2
rename V176  offensesunf_15c2
rename V177  offensesunf_16c2
rename V178  offensesunf_17c2
rename V179  offensesunf_18c2
rename V180  offensesunf_19c2
rename V181  offensesunf_20c2
rename V182  offensesunf_21c2
rename V183  offensesunf_22c2
rename V184  offensesunf_23c2
rename V185  offensesunf_24c2
rename V186  offensesunf_25c2
rename V187  offensesunf_26c2
rename V188  offenses_1c2
rename V189  offenses_2c2
rename V190  offenses_3c2
rename V191  offenses_4c2
rename V192  offenses_5c2
rename V193  offenses_6c2
rename V194  offenses_7c2
rename V195  offenses_8c2
rename V196  offenses_9c2
rename V197  offenses_10c2
rename V198  offenses_11c2
rename V199  offenses_12c2
rename V200  offenses_13c2
rename V201  offenses_14c2
rename V202  offenses_15c2
rename V203  offenses_16c2
rename V204  offenses_17c2
rename V205  offenses_18c2
rename V206  offenses_19c2
rename V207  offenses_20c2
rename V208  offenses_21c2
rename V209  offenses_22c2
rename V210  offenses_23c2
rename V211  offenses_24c2
rename V212  offenses_25c2
rename V213  offenses_26c2
rename V214  clearances_1c2
rename V215  clearances_2c2
rename V216  clearances_3c2
rename V217  clearances_4c2
rename V218  clearances_5c2
rename V219  clearances_6c2
rename V220  clearances_7c2
rename V221  clearances_8c2
rename V222  clearances_9c2
rename V223  clearances_10c2
rename V224  clearances_11c2
rename V225  clearances_12c2
rename V226  clearances_13c2
rename V227  clearances_14c2
rename V228  clearances_15c2
rename V229  clearances_16c2
rename V230  clearances_17c2
rename V231  clearances_18c2
rename V232  clearances_19c2
rename V233  clearances_20c2
rename V234  clearances_21c2
rename V235  clearances_22c2
rename V236  clearances_23c2
rename V237  clearances_24c2
rename V238  clearances_25c2
rename V239  clearances_26c2
rename V240  clearancesu18_1c2
rename V241  clearancesu18_2c2
rename V242  clearancesu18_3c2
rename V243  clearancesu18_4c2
rename V244  clearancesu18_5c2
rename V245  clearancesu18_6c2
rename V246  clearancesu18_7c2
rename V247  clearancesu18_8c2
rename V248  clearancesu18_9c2
rename V249  clearancesu18_10c2
rename V250  clearancesu18_11c2
rename V251  clearancesu18_12c2
rename V252  clearancesu18_13c2
rename V253  clearancesu18_14c2
rename V254  clearancesu18_15c2
rename V255  clearancesu18_16c2
rename V256  clearancesu18_17c2
rename V257  clearancesu18_18c2
rename V258  clearancesu18_19c2
rename V259  clearancesu18_20c2
rename V260  clearancesu18_21c2
rename V261  clearancesu18_22c2
rename V262  clearancesu18_23c2
rename V263  clearancesu18_24c2
rename V264  clearancesu18_25c2
rename V265  clearancesu18_26c2
rename V266  felonious2
rename V267  accidental2
rename V268  officerass2
rename V269  monthincl3
rename V270  datelastup3
rename V271  card0type3
rename V272  card1type3
rename V273  card2type3
rename V274  card3type3
rename V275  card4type3
rename V276 card0pt3
rename V277 card1pt3
rename V278 card2pt3
rename V279 card3pt3
rename V280  offensesunf_1c3
rename V281  offensesunf_2c3
rename V282  offensesunf_3c3
rename V283  offensesunf_4c3
rename V284  offensesunf_5c3
rename V285  offensesunf_6c3
rename V286  offensesunf_7c3
rename V287  offensesunf_8c3
rename V288  offensesunf_9c3
rename V289  offensesunf_10c3
rename V290  offensesunf_11c3
rename V291  offensesunf_12c3
rename V292  offensesunf_13c3
rename V293  offensesunf_14c3
rename V294  offensesunf_15c3
rename V295  offensesunf_16c3
rename V296  offensesunf_17c3
rename V297  offensesunf_18c3
rename V298  offensesunf_19c3
rename V299  offensesunf_20c3
rename V300  offensesunf_21c3
rename V301  offensesunf_22c3
rename V302  offensesunf_23c3
rename V303  offensesunf_24c3
rename V304  offensesunf_25c3
rename V305  offensesunf_26c3
rename V306  offenses_1c3
rename V307  offenses_2c3
rename V308  offenses_3c3
rename V309  offenses_4c3
rename V310  offenses_5c3
rename V311  offenses_6c3
rename V312  offenses_7c3
rename V313  offenses_8c3
rename V314  offenses_9c3
rename V315  offenses_10c3
rename V316  offenses_11c3
rename V317  offenses_12c3
rename V318  offenses_13c3
rename V319  offenses_14c3
rename V320  offenses_15c3
rename V321  offenses_16c3
rename V322  offenses_17c3
rename V323  offenses_18c3
rename V324  offenses_19c3
rename V325  offenses_20c3
rename V326  offenses_21c3
rename V327  offenses_22c3
rename V328  offenses_23c3
rename V329  offenses_24c3
rename V330  offenses_25c3
rename V331  offenses_26c3
rename V332  clearances_1c3
rename V333  clearances_2c3
rename V334  clearances_3c3
rename V335  clearances_4c3
rename V336  clearances_5c3
rename V337  clearances_6c3
rename V338  clearances_7c3
rename V339  clearances_8c3
rename V340  clearances_9c3
rename V341  clearances_10c3
rename V342  clearances_11c3
rename V343  clearances_12c3
rename V344  clearances_13c3
rename V345  clearances_14c3
rename V346  clearances_15c3
rename V347  clearances_16c3
rename V348  clearances_17c3
rename V349  clearances_18c3
rename V350  clearances_19c3
rename V351  clearances_20c3
rename V352  clearances_21c3
rename V353  clearances_22c3
rename V354  clearances_23c3
rename V355  clearances_24c3
rename V356  clearances_25c3
rename V357  clearances_26c3
rename V358  clearancesu18_1c3
rename V359  clearancesu18_2c3
rename V360  clearancesu18_3c3
rename V361  clearancesu18_4c3
rename V362  clearancesu18_5c3
rename V363  clearancesu18_6c3
rename V364  clearancesu18_7c3
rename V365  clearancesu18_8c3
rename V366  clearancesu18_9c3
rename V367  clearancesu18_10c3
rename V368  clearancesu18_11c3
rename V369  clearancesu18_12c3
rename V370  clearancesu18_13c3
rename V371  clearancesu18_14c3
rename V372  clearancesu18_15c3
rename V373  clearancesu18_16c3
rename V374  clearancesu18_17c3
rename V375  clearancesu18_18c3
rename V376  clearancesu18_19c3
rename V377  clearancesu18_20c3
rename V378  clearancesu18_21c3
rename V379  clearancesu18_22c3
rename V380  clearancesu18_23c3
rename V381  clearancesu18_24c3
rename V382  clearancesu18_25c3
rename V383  clearancesu18_26c3
rename V384  felonious3
rename V385  accidental3
rename V386  officerass3
rename V387  monthincl4
rename V388  datelastup4
rename V389  card0type4
rename V390  card1type4
rename V391  card2type4
rename V392  card3type4
rename V393  card4type4
rename V394 card0pt4
rename V395 card1pt4
rename V396 card2pt4
rename V397 card3pt4
rename V398  offensesunf_1c4
rename V399  offensesunf_2c4
rename V400  offensesunf_3c4
rename V401  offensesunf_4c4
rename V402  offensesunf_5c4
rename V403  offensesunf_6c4
rename V404  offensesunf_7c4
rename V405  offensesunf_8c4
rename V406  offensesunf_9c4
rename V407  offensesunf_10c4
rename V408  offensesunf_11c4
rename V409  offensesunf_12c4
rename V410  offensesunf_13c4
rename V411  offensesunf_14c4
rename V412  offensesunf_15c4
rename V413  offensesunf_16c4
rename V414  offensesunf_17c4
rename V415  offensesunf_18c4
rename V416  offensesunf_19c4
rename V417  offensesunf_20c4
rename V418  offensesunf_21c4
rename V419  offensesunf_22c4
rename V420  offensesunf_23c4
rename V421  offensesunf_24c4
rename V422  offensesunf_25c4
rename V423  offensesunf_26c4
rename V424  offenses_1c4
rename V425  offenses_2c4
rename V426  offenses_3c4
rename V427  offenses_4c4
rename V428  offenses_5c4
rename V429  offenses_6c4
rename V430  offenses_7c4
rename V431  offenses_8c4
rename V432  offenses_9c4
rename V433  offenses_10c4
rename V434  offenses_11c4
rename V435  offenses_12c4
rename V436  offenses_13c4
rename V437  offenses_14c4
rename V438  offenses_15c4
rename V439  offenses_16c4
rename V440  offenses_17c4
rename V441  offenses_18c4
rename V442  offenses_19c4
rename V443  offenses_20c4
rename V444  offenses_21c4
rename V445  offenses_22c4
rename V446  offenses_23c4
rename V447  offenses_24c4
rename V448  offenses_25c4
rename V449  offenses_26c4
rename V450  clearances_1c4
rename V451  clearances_2c4
rename V452  clearances_3c4
rename V453  clearances_4c4
rename V454  clearances_5c4
rename V455  clearances_6c4
rename V456  clearances_7c4
rename V457  clearances_8c4
rename V458  clearances_9c4
rename V459  clearances_10c4
rename V460  clearances_11c4
rename V461  clearances_12c4
rename V462  clearances_13c4
rename V463  clearances_14c4
rename V464  clearances_15c4
rename V465  clearances_16c4
rename V466  clearances_17c4
rename V467  clearances_18c4
rename V468  clearances_19c4
rename V469  clearances_20c4
rename V470  clearances_21c4
rename V471  clearances_22c4
rename V472  clearances_23c4
rename V473  clearances_24c4
rename V474  clearances_25c4
rename V475  clearances_26c4
rename V476  clearancesu18_1c4
rename V477  clearancesu18_2c4
rename V478  clearancesu18_3c4
rename V479  clearancesu18_4c4
rename V480  clearancesu18_5c4
rename V481  clearancesu18_6c4
rename V482  clearancesu18_7c4
rename V483  clearancesu18_8c4
rename V484  clearancesu18_9c4
rename V485  clearancesu18_10c4
rename V486  clearancesu18_11c4
rename V487  clearancesu18_12c4
rename V488  clearancesu18_13c4
rename V489  clearancesu18_14c4
rename V490  clearancesu18_15c4
rename V491  clearancesu18_16c4
rename V492  clearancesu18_17c4
rename V493  clearancesu18_18c4
rename V494  clearancesu18_19c4
rename V495  clearancesu18_20c4
rename V496  clearancesu18_21c4
rename V497  clearancesu18_22c4
rename V498  clearancesu18_23c4
rename V499  clearancesu18_24c4
rename V500  clearancesu18_25c4
rename V501  clearancesu18_26c4
rename V502  felonious4
rename V503  accidental4
rename V504  officerass4
rename V505  monthincl5
rename V506  datelastup5
rename V507  card0type5
rename V508  card1type5
rename V509  card2type5
rename V510  card3type5
rename V511  card4type5
rename V512 card0pt5
rename V513 card1pt5
rename V514 card2pt5
rename V515 card3pt5
rename V516  offensesunf_1c5
rename V517  offensesunf_2c5
rename V518  offensesunf_3c5
rename V519  offensesunf_4c5
rename V520  offensesunf_5c5
rename V521  offensesunf_6c5
rename V522  offensesunf_7c5
rename V523  offensesunf_8c5
rename V524  offensesunf_9c5
rename V525  offensesunf_10c5
rename V526  offensesunf_11c5
rename V527  offensesunf_12c5
rename V528  offensesunf_13c5
rename V529  offensesunf_14c5
rename V530  offensesunf_15c5
rename V531  offensesunf_16c5
rename V532  offensesunf_17c5
rename V533  offensesunf_18c5
rename V534  offensesunf_19c5
rename V535  offensesunf_20c5
rename V536  offensesunf_21c5
rename V537  offensesunf_22c5
rename V538  offensesunf_23c5
rename V539  offensesunf_24c5
rename V540  offensesunf_25c5
rename V541  offensesunf_26c5
rename V542  offenses_1c5
rename V543  offenses_2c5
rename V544  offenses_3c5
rename V545  offenses_4c5
rename V546  offenses_5c5
rename V547  offenses_6c5
rename V548  offenses_7c5
rename V549  offenses_8c5
rename V550  offenses_9c5
rename V551  offenses_10c5
rename V552  offenses_11c5
rename V553  offenses_12c5
rename V554  offenses_13c5
rename V555  offenses_14c5
rename V556  offenses_15c5
rename V557  offenses_16c5
rename V558  offenses_17c5
rename V559  offenses_18c5
rename V560  offenses_19c5
rename V561  offenses_20c5
rename V562  offenses_21c5
rename V563  offenses_22c5
rename V564  offenses_23c5
rename V565  offenses_24c5
rename V566  offenses_25c5
rename V567  offenses_26c5
rename V568  clearances_1c5
rename V569  clearances_2c5
rename V570  clearances_3c5
rename V571  clearances_4c5
rename V572  clearances_5c5
rename V573  clearances_6c5
rename V574  clearances_7c5
rename V575  clearances_8c5
rename V576  clearances_9c5
rename V577  clearances_10c5
rename V578  clearances_11c5
rename V579  clearances_12c5
rename V580  clearances_13c5
rename V581  clearances_14c5
rename V582  clearances_15c5
rename V583  clearances_16c5
rename V584  clearances_17c5
rename V585  clearances_18c5
rename V586  clearances_19c5
rename V587  clearances_20c5
rename V588  clearances_21c5
rename V589  clearances_22c5
rename V590  clearances_23c5
rename V591  clearances_24c5
rename V592  clearances_25c5
rename V593  clearances_26c5
rename V594  clearancesu18_1c5
rename V595  clearancesu18_2c5
rename V596  clearancesu18_3c5
rename V597  clearancesu18_4c5
rename V598  clearancesu18_5c5
rename V599  clearancesu18_6c5
rename V600  clearancesu18_7c5
rename V601  clearancesu18_8c5
rename V602  clearancesu18_9c5
rename V603  clearancesu18_10c5
rename V604  clearancesu18_11c5
rename V605  clearancesu18_12c5
rename V606  clearancesu18_13c5
rename V607  clearancesu18_14c5
rename V608  clearancesu18_15c5
rename V609  clearancesu18_16c5
rename V610  clearancesu18_17c5
rename V611  clearancesu18_18c5
rename V612  clearancesu18_19c5
rename V613  clearancesu18_20c5
rename V614  clearancesu18_21c5
rename V615  clearancesu18_22c5
rename V616  clearancesu18_23c5
rename V617  clearancesu18_24c5
rename V618  clearancesu18_25c5
rename V619  clearancesu18_26c5
rename V620  felonious5
rename V621  accidental5
rename V622  officerass5
rename V623  monthincl6
rename V624  datelastup6
rename V625  card0type6
rename V626  card1type6
rename V627  card2type6
rename V628  card3type6
rename V629  card4type6
rename V630 card0pt6
rename V631 card1pt6
rename V632 card2pt6
rename V633 card3pt6
rename V634  offensesunf_1c6
rename V635  offensesunf_2c6
rename V636  offensesunf_3c6
rename V637  offensesunf_4c6
rename V638  offensesunf_5c6
rename V639  offensesunf_6c6
rename V640  offensesunf_7c6
rename V641  offensesunf_8c6
rename V642  offensesunf_9c6
rename V643  offensesunf_10c6
rename V644  offensesunf_11c6
rename V645  offensesunf_12c6
rename V646  offensesunf_13c6
rename V647  offensesunf_14c6
rename V648  offensesunf_15c6
rename V649  offensesunf_16c6
rename V650  offensesunf_17c6
rename V651  offensesunf_18c6
rename V652  offensesunf_19c6
rename V653  offensesunf_20c6
rename V654  offensesunf_21c6
rename V655  offensesunf_22c6
rename V656  offensesunf_23c6
rename V657  offensesunf_24c6
rename V658  offensesunf_25c6
rename V659  offensesunf_26c6
rename V660  offenses_1c6
rename V661  offenses_2c6
rename V662  offenses_3c6
rename V663  offenses_4c6
rename V664  offenses_5c6
rename V665  offenses_6c6
rename V666  offenses_7c6
rename V667  offenses_8c6
rename V668  offenses_9c6
rename V669  offenses_10c6
rename V670  offenses_11c6
rename V671  offenses_12c6
rename V672  offenses_13c6
rename V673  offenses_14c6
rename V674  offenses_15c6
rename V675  offenses_16c6
rename V676  offenses_17c6
rename V677  offenses_18c6
rename V678  offenses_19c6
rename V679  offenses_20c6
rename V680  offenses_21c6
rename V681  offenses_22c6
rename V682  offenses_23c6
rename V683  offenses_24c6
rename V684  offenses_25c6
rename V685  offenses_26c6
rename V686  clearances_1c6
rename V687  clearances_2c6
rename V688  clearances_3c6
rename V689  clearances_4c6
rename V690  clearances_5c6
rename V691  clearances_6c6
rename V692  clearances_7c6
rename V693  clearances_8c6
rename V694  clearances_9c6
rename V695  clearances_10c6
rename V696  clearances_11c6
rename V697  clearances_12c6
rename V698  clearances_13c6
rename V699  clearances_14c6
rename V700  clearances_15c6
rename V701  clearances_16c6
rename V702  clearances_17c6
rename V703  clearances_18c6
rename V704  clearances_19c6
rename V705  clearances_20c6
rename V706  clearances_21c6
rename V707  clearances_22c6
rename V708  clearances_23c6
rename V709  clearances_24c6
rename V710  clearances_25c6
rename V711  clearances_26c6
rename V712  clearancesu18_1c6
rename V713  clearancesu18_2c6
rename V714  clearancesu18_3c6
rename V715  clearancesu18_4c6
rename V716  clearancesu18_5c6
rename V717  clearancesu18_6c6
rename V718  clearancesu18_7c6
rename V719  clearancesu18_8c6
rename V720  clearancesu18_9c6
rename V721  clearancesu18_10c6
rename V722  clearancesu18_11c6
rename V723  clearancesu18_12c6
rename V724  clearancesu18_13c6
rename V725  clearancesu18_14c6
rename V726  clearancesu18_15c6
rename V727  clearancesu18_16c6
rename V728  clearancesu18_17c6
rename V729  clearancesu18_18c6
rename V730  clearancesu18_19c6
rename V731  clearancesu18_20c6
rename V732  clearancesu18_21c6
rename V733  clearancesu18_22c6
rename V734  clearancesu18_23c6
rename V735  clearancesu18_24c6
rename V736  clearancesu18_25c6
rename V737  clearancesu18_26c6
rename V738  felonious6
rename V739  accidental6
rename V740  officerass6
rename V741  monthincl7
rename V742  datelastup7
rename V743  card0type7
rename V744  card1type7
rename V745  card2type7
rename V746  card3type7
rename V747  card4type7
rename V748 card0pt7
rename V749 card1pt7
rename V750 card2pt7
rename V751 card3pt7
rename V752  offensesunf_1c7
rename V753  offensesunf_2c7
rename V754  offensesunf_3c7
rename V755  offensesunf_4c7
rename V756  offensesunf_5c7
rename V757  offensesunf_6c7
rename V758  offensesunf_7c7
rename V759  offensesunf_8c7
rename V760  offensesunf_9c7
rename V761  offensesunf_10c7
rename V762  offensesunf_11c7
rename V763  offensesunf_12c7
rename V764  offensesunf_13c7
rename V765  offensesunf_14c7
rename V766  offensesunf_15c7
rename V767  offensesunf_16c7
rename V768  offensesunf_17c7
rename V769  offensesunf_18c7
rename V770  offensesunf_19c7
rename V771  offensesunf_20c7
rename V772  offensesunf_21c7
rename V773  offensesunf_22c7
rename V774  offensesunf_23c7
rename V775  offensesunf_24c7
rename V776  offensesunf_25c7
rename V777  offensesunf_26c7
rename V778  offenses_1c7
rename V779  offenses_2c7
rename V780  offenses_3c7
rename V781  offenses_4c7
rename V782  offenses_5c7
rename V783  offenses_6c7
rename V784  offenses_7c7
rename V785  offenses_8c7
rename V786  offenses_9c7
rename V787  offenses_10c7
rename V788  offenses_11c7
rename V789  offenses_12c7
rename V790  offenses_13c7
rename V791  offenses_14c7
rename V792  offenses_15c7
rename V793  offenses_16c7
rename V794  offenses_17c7
rename V795  offenses_18c7
rename V796  offenses_19c7
rename V797  offenses_20c7
rename V798  offenses_21c7
rename V799  offenses_22c7
rename V800  offenses_23c7
rename V801  offenses_24c7
rename V802  offenses_25c7
rename V803  offenses_26c7
rename V804  clearances_1c7
rename V805  clearances_2c7
rename V806  clearances_3c7
rename V807  clearances_4c7
rename V808  clearances_5c7
rename V809  clearances_6c7
rename V810  clearances_7c7
rename V811  clearances_8c7
rename V812  clearances_9c7
rename V813  clearances_10c7
rename V814  clearances_11c7
rename V815  clearances_12c7
rename V816  clearances_13c7
rename V817  clearances_14c7
rename V818  clearances_15c7
rename V819  clearances_16c7
rename V820  clearances_17c7
rename V821  clearances_18c7
rename V822  clearances_19c7
rename V823  clearances_20c7
rename V824  clearances_21c7
rename V825  clearances_22c7
rename V826  clearances_23c7
rename V827  clearances_24c7
rename V828  clearances_25c7
rename V829  clearances_26c7
rename V830  clearancesu18_1c7
rename V831  clearancesu18_2c7
rename V832  clearancesu18_3c7
rename V833  clearancesu18_4c7
rename V834  clearancesu18_5c7
rename V835  clearancesu18_6c7
rename V836  clearancesu18_7c7
rename V837  clearancesu18_8c7
rename V838  clearancesu18_9c7
rename V839  clearancesu18_10c7
rename V840  clearancesu18_11c7
rename V841  clearancesu18_12c7
rename V842  clearancesu18_13c7
rename V843  clearancesu18_14c7
rename V844  clearancesu18_15c7
rename V845  clearancesu18_16c7
rename V846  clearancesu18_17c7
rename V847  clearancesu18_18c7
rename V848  clearancesu18_19c7
rename V849  clearancesu18_20c7
rename V850  clearancesu18_21c7
rename V851  clearancesu18_22c7
rename V852  clearancesu18_23c7
rename V853  clearancesu18_24c7
rename V854  clearancesu18_25c7
rename V855  clearancesu18_26c7
rename V856  felonious7
rename V857  accidental7
rename V858  officerass7
rename V859  monthincl8
rename V860  datelastup8
rename V861  card0type8
rename V862  card1type8
rename V863  card2type8
rename V864  card3type8
rename V865  card4type8
rename V866 card0pt8
rename V867 card1pt8
rename V868 card2pt8
rename V869 card3pt8
rename V870  offensesunf_1c8
rename V871  offensesunf_2c8
rename V872  offensesunf_3c8
rename V873  offensesunf_4c8
rename V874  offensesunf_5c8
rename V875  offensesunf_6c8
rename V876  offensesunf_7c8
rename V877  offensesunf_8c8
rename V878  offensesunf_9c8
rename V879  offensesunf_10c8
rename V880  offensesunf_11c8
rename V881  offensesunf_12c8
rename V882  offensesunf_13c8
rename V883  offensesunf_14c8
rename V884  offensesunf_15c8
rename V885  offensesunf_16c8
rename V886  offensesunf_17c8
rename V887  offensesunf_18c8
rename V888  offensesunf_19c8
rename V889  offensesunf_20c8
rename V890  offensesunf_21c8
rename V891  offensesunf_22c8
rename V892  offensesunf_23c8
rename V893  offensesunf_24c8
rename V894  offensesunf_25c8
rename V895  offensesunf_26c8
rename V896  offenses_1c8
rename V897  offenses_2c8
rename V898  offenses_3c8
rename V899  offenses_4c8
rename V900  offenses_5c8
rename V901  offenses_6c8
rename V902  offenses_7c8
rename V903  offenses_8c8
rename V904  offenses_9c8
rename V905  offenses_10c8
rename V906  offenses_11c8
rename V907  offenses_12c8
rename V908  offenses_13c8
rename V909  offenses_14c8
rename V910  offenses_15c8
rename V911  offenses_16c8
rename V912  offenses_17c8
rename V913  offenses_18c8
rename V914  offenses_19c8
rename V915  offenses_20c8
rename V916  offenses_21c8
rename V917  offenses_22c8
rename V918  offenses_23c8
rename V919  offenses_24c8
rename V920  offenses_25c8
rename V921  offenses_26c8
rename V922  clearances_1c8
rename V923  clearances_2c8
rename V924  clearances_3c8
rename V925  clearances_4c8
rename V926  clearances_5c8
rename V927  clearances_6c8
rename V928  clearances_7c8
rename V929  clearances_8c8
rename V930  clearances_9c8
rename V931  clearances_10c8
rename V932  clearances_11c8
rename V933  clearances_12c8
rename V934  clearances_13c8
rename V935  clearances_14c8
rename V936  clearances_15c8
rename V937  clearances_16c8
rename V938  clearances_17c8
rename V939  clearances_18c8
rename V940  clearances_19c8
rename V941  clearances_20c8
rename V942  clearances_21c8
rename V943  clearances_22c8
rename V944  clearances_23c8
rename V945  clearances_24c8
rename V946  clearances_25c8
rename V947  clearances_26c8
rename V948  clearancesu18_1c8
rename V949  clearancesu18_2c8
rename V950  clearancesu18_3c8
rename V951  clearancesu18_4c8
rename V952  clearancesu18_5c8
rename V953  clearancesu18_6c8
rename V954  clearancesu18_7c8
rename V955  clearancesu18_8c8
rename V956  clearancesu18_9c8
rename V957  clearancesu18_10c8
rename V958  clearancesu18_11c8
rename V959  clearancesu18_12c8
rename V960  clearancesu18_13c8
rename V961  clearancesu18_14c8
rename V962  clearancesu18_15c8
rename V963  clearancesu18_16c8
rename V964  clearancesu18_17c8
rename V965  clearancesu18_18c8
rename V966  clearancesu18_19c8
rename V967  clearancesu18_20c8
rename V968  clearancesu18_21c8
rename V969  clearancesu18_22c8
rename V970  clearancesu18_23c8
rename V971  clearancesu18_24c8
rename V972  clearancesu18_25c8
rename V973  clearancesu18_26c8
rename V974  felonious8
rename V975  accidental8
rename V976  officerass8
rename V977  monthincl9
rename V978  datelastup9
rename V979  card0type9
rename V980  card1type9
rename V981  card2type9
rename V982  card3type9
rename V983  card4type9
rename V984 card0pt9
rename V985 card1pt9
rename V986 card2pt9
rename V987 card3pt9
rename V988  offensesunf_1c9
rename V989  offensesunf_2c9
rename V990  offensesunf_3c9
rename V991  offensesunf_4c9
rename V992  offensesunf_5c9
rename V993  offensesunf_6c9
rename V994  offensesunf_7c9
rename V995  offensesunf_8c9
rename V996  offensesunf_9c9
rename V997  offensesunf_10c9
rename V998  offensesunf_11c9
rename V999  offensesunf_12c9
rename V1000  offensesunf_13c9
rename V1001  offensesunf_14c9
rename V1002  offensesunf_15c9
rename V1003  offensesunf_16c9
rename V1004  offensesunf_17c9
rename V1005  offensesunf_18c9
rename V1006  offensesunf_19c9
rename V1007  offensesunf_20c9
rename V1008  offensesunf_21c9
rename V1009  offensesunf_22c9
rename V1010  offensesunf_23c9
rename V1011  offensesunf_24c9
rename V1012  offensesunf_25c9
rename V1013  offensesunf_26c9
rename V1014  offenses_1c9
rename V1015  offenses_2c9
rename V1016  offenses_3c9
rename V1017  offenses_4c9
rename V1018  offenses_5c9
rename V1019  offenses_6c9
rename V1020  offenses_7c9
rename V1021  offenses_8c9
rename V1022  offenses_9c9
rename V1023  offenses_10c9
rename V1024  offenses_11c9
rename V1025  offenses_12c9
rename V1026  offenses_13c9
rename V1027  offenses_14c9
rename V1028  offenses_15c9
rename V1029  offenses_16c9
rename V1030  offenses_17c9
rename V1031  offenses_18c9
rename V1032  offenses_19c9
rename V1033  offenses_20c9
rename V1034  offenses_21c9
rename V1035  offenses_22c9
rename V1036  offenses_23c9
rename V1037  offenses_24c9
rename V1038  offenses_25c9
rename V1039  offenses_26c9
rename V1040  clearances_1c9
rename V1041  clearances_2c9
rename V1042  clearances_3c9
rename V1043  clearances_4c9
rename V1044  clearances_5c9
rename V1045  clearances_6c9
rename V1046  clearances_7c9
rename V1047  clearances_8c9
rename V1048  clearances_9c9
rename V1049  clearances_10c9
rename V1050  clearances_11c9
rename V1051  clearances_12c9
rename V1052  clearances_13c9
rename V1053  clearances_14c9
rename V1054  clearances_15c9
rename V1055  clearances_16c9
rename V1056  clearances_17c9
rename V1057  clearances_18c9
rename V1058  clearances_19c9
rename V1059  clearances_20c9
rename V1060  clearances_21c9
rename V1061  clearances_22c9
rename V1062  clearances_23c9
rename V1063  clearances_24c9
rename V1064  clearances_25c9
rename V1065  clearances_26c9
rename V1066  clearancesu18_1c9
rename V1067  clearancesu18_2c9
rename V1068  clearancesu18_3c9
rename V1069  clearancesu18_4c9
rename V1070  clearancesu18_5c9
rename V1071  clearancesu18_6c9
rename V1072  clearancesu18_7c9
rename V1073  clearancesu18_8c9
rename V1074  clearancesu18_9c9
rename V1075  clearancesu18_10c9
rename V1076  clearancesu18_11c9
rename V1077  clearancesu18_12c9
rename V1078  clearancesu18_13c9
rename V1079  clearancesu18_14c9
rename V1080  clearancesu18_15c9
rename V1081  clearancesu18_16c9
rename V1082  clearancesu18_17c9
rename V1083  clearancesu18_18c9
rename V1084  clearancesu18_19c9
rename V1085  clearancesu18_20c9
rename V1086  clearancesu18_21c9
rename V1087  clearancesu18_22c9
rename V1088  clearancesu18_23c9
rename V1089  clearancesu18_24c9
rename V1090  clearancesu18_25c9
rename V1091  clearancesu18_26c9
rename V1092  felonious9
rename V1093  accidental9
rename V1094  officerass9
rename V1095  monthincl10
rename V1096  datelastup10
rename V1097  card0type10
rename V1098  card1type10
rename V1099  card2type10
rename V1100  card3type10
rename V1101  card4type10
rename V1102 card0pt10
rename V1103 card1pt10
rename V1104 card2pt10
rename V1105 card3pt10
rename V1106  offensesunf_1c10
rename V1107  offensesunf_2c10
rename V1108  offensesunf_3c10
rename V1109  offensesunf_4c10
rename V1110  offensesunf_5c10
rename V1111  offensesunf_6c10
rename V1112  offensesunf_7c10
rename V1113  offensesunf_8c10
rename V1114  offensesunf_9c10
rename V1115  offensesunf_10c10
rename V1116  offensesunf_11c10
rename V1117  offensesunf_12c10
rename V1118  offensesunf_13c10
rename V1119  offensesunf_14c10
rename V1120  offensesunf_15c10
rename V1121  offensesunf_16c10
rename V1122  offensesunf_17c10
rename V1123  offensesunf_18c10
rename V1124  offensesunf_19c10
rename V1125  offensesunf_20c10
rename V1126  offensesunf_21c10
rename V1127  offensesunf_22c10
rename V1128  offensesunf_23c10
rename V1129  offensesunf_24c10
rename V1130  offensesunf_25c10
rename V1131  offensesunf_26c10
rename V1132  offenses_1c10
rename V1133  offenses_2c10
rename V1134  offenses_3c10
rename V1135  offenses_4c10
rename V1136  offenses_5c10
rename V1137  offenses_6c10
rename V1138  offenses_7c10
rename V1139  offenses_8c10
rename V1140  offenses_9c10
rename V1141  offenses_10c10
rename V1142  offenses_11c10
rename V1143  offenses_12c10
rename V1144  offenses_13c10
rename V1145  offenses_14c10
rename V1146  offenses_15c10
rename V1147  offenses_16c10
rename V1148  offenses_17c10
rename V1149  offenses_18c10
rename V1150  offenses_19c10
rename V1151  offenses_20c10
rename V1152  offenses_21c10
rename V1153  offenses_22c10
rename V1154  offenses_23c10
rename V1155  offenses_24c10
rename V1156  offenses_25c10
rename V1157  offenses_26c10
rename V1158  clearances_1c10
rename V1159  clearances_2c10
rename V1160  clearances_3c10
rename V1161  clearances_4c10
rename V1162  clearances_5c10
rename V1163  clearances_6c10
rename V1164  clearances_7c10
rename V1165  clearances_8c10
rename V1166  clearances_9c10
rename V1167  clearances_10c10
rename V1168  clearances_11c10
rename V1169  clearances_12c10
rename V1170  clearances_13c10
rename V1171  clearances_14c10
rename V1172  clearances_15c10
rename V1173  clearances_16c10
rename V1174  clearances_17c10
rename V1175  clearances_18c10
rename V1176  clearances_19c10
rename V1177  clearances_20c10
rename V1178  clearances_21c10
rename V1179  clearances_22c10
rename V1180  clearances_23c10
rename V1181  clearances_24c10
rename V1182  clearances_25c10
rename V1183  clearances_26c10
rename V1184  clearancesu18_1c10
rename V1185  clearancesu18_2c10
rename V1186  clearancesu18_3c10
rename V1187  clearancesu18_4c10
rename V1188  clearancesu18_5c10
rename V1189  clearancesu18_6c10
rename V1190  clearancesu18_7c10
rename V1191  clearancesu18_8c10
rename V1192  clearancesu18_9c10
rename V1193  clearancesu18_10c10
rename V1194  clearancesu18_11c10
rename V1195  clearancesu18_12c10
rename V1196  clearancesu18_13c10
rename V1197  clearancesu18_14c10
rename V1198  clearancesu18_15c10
rename V1199  clearancesu18_16c10
rename V1200  clearancesu18_17c10
rename V1201  clearancesu18_18c10
rename V1202  clearancesu18_19c10
rename V1203  clearancesu18_20c10
rename V1204  clearancesu18_21c10
rename V1205  clearancesu18_22c10
rename V1206  clearancesu18_23c10
rename V1207  clearancesu18_24c10
rename V1208  clearancesu18_25c10
rename V1209  clearancesu18_26c10
rename V1210  felonious10
rename V1211  accidental10
rename V1212  officerass10
rename V1213  monthincl11
rename V1214  datelastup11
rename V1215  card0type11
rename V1216  card1type11
rename V1217  card2type11
rename V1218  card3type11
rename V1219  card4type11
rename V1220 card0pt11
rename V1221 card1pt11
rename V1222 card2pt11
rename V1223 card3pt11
rename V1224  offensesunf_1c11
rename V1225  offensesunf_2c11
rename V1226  offensesunf_3c11
rename V1227  offensesunf_4c11
rename V1228  offensesunf_5c11
rename V1229  offensesunf_6c11
rename V1230  offensesunf_7c11
rename V1231  offensesunf_8c11
rename V1232  offensesunf_9c11
rename V1233  offensesunf_10c11
rename V1234  offensesunf_11c11
rename V1235  offensesunf_12c11
rename V1236  offensesunf_13c11
rename V1237  offensesunf_14c11
rename V1238  offensesunf_15c11
rename V1239  offensesunf_16c11
rename V1240  offensesunf_17c11
rename V1241  offensesunf_18c11
rename V1242  offensesunf_19c11
rename V1243  offensesunf_20c11
rename V1244  offensesunf_21c11
rename V1245  offensesunf_22c11
rename V1246  offensesunf_23c11
rename V1247  offensesunf_24c11
rename V1248  offensesunf_25c11
rename V1249  offensesunf_26c11
rename V1250  offenses_1c11
rename V1251  offenses_2c11
rename V1252  offenses_3c11
rename V1253  offenses_4c11
rename V1254  offenses_5c11
rename V1255  offenses_6c11
rename V1256  offenses_7c11
rename V1257  offenses_8c11
rename V1258  offenses_9c11
rename V1259  offenses_10c11
rename V1260  offenses_11c11
rename V1261  offenses_12c11
rename V1262  offenses_13c11
rename V1263  offenses_14c11
rename V1264  offenses_15c11
rename V1265  offenses_16c11
rename V1266  offenses_17c11
rename V1267  offenses_18c11
rename V1268  offenses_19c11
rename V1269  offenses_20c11
rename V1270  offenses_21c11
rename V1271  offenses_22c11
rename V1272  offenses_23c11
rename V1273  offenses_24c11
rename V1274  offenses_25c11
rename V1275  offenses_26c11
rename V1276  clearances_1c11
rename V1277  clearances_2c11
rename V1278  clearances_3c11
rename V1279  clearances_4c11
rename V1280  clearances_5c11
rename V1281  clearances_6c11
rename V1282  clearances_7c11
rename V1283  clearances_8c11
rename V1284  clearances_9c11
rename V1285  clearances_10c11
rename V1286  clearances_11c11
rename V1287  clearances_12c11
rename V1288  clearances_13c11
rename V1289  clearances_14c11
rename V1290  clearances_15c11
rename V1291  clearances_16c11
rename V1292  clearances_17c11
rename V1293  clearances_18c11
rename V1294  clearances_19c11
rename V1295  clearances_20c11
rename V1296  clearances_21c11
rename V1297  clearances_22c11
rename V1298  clearances_23c11
rename V1299  clearances_24c11
rename V1300  clearances_25c11
rename V1301  clearances_26c11
rename V1302  clearancesu18_1c11
rename V1303  clearancesu18_2c11
rename V1304  clearancesu18_3c11
rename V1305  clearancesu18_4c11
rename V1306  clearancesu18_5c11
rename V1307  clearancesu18_6c11
rename V1308  clearancesu18_7c11
rename V1309  clearancesu18_8c11
rename V1310  clearancesu18_9c11
rename V1311  clearancesu18_10c11
rename V1312  clearancesu18_11c11
rename V1313  clearancesu18_12c11
rename V1314  clearancesu18_13c11
rename V1315  clearancesu18_14c11
rename V1316  clearancesu18_15c11
rename V1317  clearancesu18_16c11
rename V1318  clearancesu18_17c11
rename V1319  clearancesu18_18c11
rename V1320  clearancesu18_19c11
rename V1321  clearancesu18_20c11
rename V1322  clearancesu18_21c11
rename V1323  clearancesu18_22c11
rename V1324  clearancesu18_23c11
rename V1325  clearancesu18_24c11
rename V1326  clearancesu18_25c11
rename V1327  clearancesu18_26c11
rename V1328  felonious11
rename V1329  accidental11
rename V1330  officerass11
rename V1331  monthincl12
rename V1332  datelastup12
rename V1333  card0type12
rename V1334  card1type12
rename V1335  card2type12
rename V1336  card3type12
rename V1337  card4type12
rename V1338 card0pt12
rename V1339 card1pt12
rename V1340 card2pt12
rename V1341 card3pt12
rename V1342  offensesunf_1c12
rename V1343  offensesunf_2c12
rename V1344  offensesunf_3c12
rename V1345  offensesunf_4c12
rename V1346  offensesunf_5c12
rename V1347  offensesunf_6c12
rename V1348  offensesunf_7c12
rename V1349  offensesunf_8c12
rename V1350  offensesunf_9c12
rename V1351  offensesunf_10c12
rename V1352  offensesunf_11c12
rename V1353  offensesunf_12c12
rename V1354  offensesunf_13c12
rename V1355  offensesunf_14c12
rename V1356  offensesunf_15c12
rename V1357  offensesunf_16c12
rename V1358  offensesunf_17c12
rename V1359  offensesunf_18c12
rename V1360  offensesunf_19c12
rename V1361  offensesunf_20c12
rename V1362  offensesunf_21c12
rename V1363  offensesunf_22c12
rename V1364  offensesunf_23c12
rename V1365  offensesunf_24c12
rename V1366  offensesunf_25c12
rename V1367  offensesunf_26c12
rename V1368  offenses_1c12
rename V1369  offenses_2c12
rename V1370  offenses_3c12
rename V1371  offenses_4c12
rename V1372  offenses_5c12
rename V1373  offenses_6c12
rename V1374  offenses_7c12
rename V1375  offenses_8c12
rename V1376  offenses_9c12
rename V1377  offenses_10c12
rename V1378  offenses_11c12
rename V1379  offenses_12c12
rename V1380  offenses_13c12
rename V1381  offenses_14c12
rename V1382  offenses_15c12
rename V1383  offenses_16c12
rename V1384  offenses_17c12
rename V1385  offenses_18c12
rename V1386  offenses_19c12
rename V1387  offenses_20c12
rename V1388  offenses_21c12
rename V1389  offenses_22c12
rename V1390  offenses_23c12
rename V1391  offenses_24c12
rename V1392  offenses_25c12
rename V1393  offenses_26c12
rename V1394  clearances_1c12
rename V1395  clearances_2c12
rename V1396  clearances_3c12
rename V1397  clearances_4c12
rename V1398  clearances_5c12
rename V1399  clearances_6c12
rename V1400  clearances_7c12
rename V1401  clearances_8c12
rename V1402  clearances_9c12
rename V1403  clearances_10c12
rename V1404  clearances_11c12
rename V1405  clearances_12c12
rename V1406  clearances_13c12
rename V1407  clearances_14c12
rename V1408  clearances_15c12
rename V1409  clearances_16c12
rename V1410  clearances_17c12
rename V1411  clearances_18c12
rename V1412  clearances_19c12
rename V1413  clearances_20c12
rename V1414  clearances_21c12
rename V1415  clearances_22c12
rename V1416  clearances_23c12
rename V1417  clearances_24c12
rename V1418  clearances_25c12
rename V1419  clearances_26c12
rename V1420  clearancesu18_1c12
rename V1421  clearancesu18_2c12
rename V1422  clearancesu18_3c12
rename V1423  clearancesu18_4c12
rename V1424  clearancesu18_5c12
rename V1425  clearancesu18_6c12
rename V1426  clearancesu18_7c12
rename V1427  clearancesu18_8c12
rename V1428  clearancesu18_9c12
rename V1429  clearancesu18_10c12
rename V1430  clearancesu18_11c12
rename V1431  clearancesu18_12c12
rename V1432  clearancesu18_13c12
rename V1433  clearancesu18_14c12
rename V1434  clearancesu18_15c12
rename V1435  clearancesu18_16c12
rename V1436  clearancesu18_17c12
rename V1437  clearancesu18_18c12
rename V1438  clearancesu18_19c12
rename V1439  clearancesu18_20c12
rename V1440  clearancesu18_21c12
rename V1441  clearancesu18_22c12
rename V1442  clearancesu18_23c12
rename V1443  clearancesu18_24c12
rename V1444  clearancesu18_25c12
rename V1445  clearancesu18_26c12
rename V1446  felonious12
rename V1447  accidental12
rename V1448  officerass12

merge 1:1 ori year using rawdata\UCR\ucr_m
drop _merge
save rawdata\UCR\ucr_m, replace
}


///Clean database
*Some years as 99 and some as 1999
replace year=year+1900 if year<100

///Summary statistics
*Number of ORI per year
tab year
*Loose some ORI in 1962
*Population per year
egen pop=rowtotal(pop1 pop2 pop3)
egen tot_pop=total(pop), by(year)
bysort year: sum tot_pop
save rawdata\UCR\ucr_m, replace

///////////////////////////////////////////////////////////////////////////////////////////
///Join with bridge////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////
use "intermediatedata\bridge_final.dta", clear
drop if V3==""
drop _merge

keep FSTATE FCOUNTY LAT LONG V3 FPLACE PLACENM FMSA FMSANAME GOVNAME GOVTYPE AGENTYPE SPECFUNC MULTPLC original_fipsMSA-city_center
rename V3 ori
merge 1:m ori using rawdata\UCR\ucr_m
drop if _merge!=3

///////////////////////////////////////////////////////////////////////////////////////////
///Clean variables/////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////
*Replace Card variables as missing if value=Not Updated 
forval mm=1/12{
replace card0type`mm'=. if card0type`mm'==0 | card0type`mm'==9
replace card1type`mm'=. if card1type`mm'==0 | card1type`mm'==9
replace card2type`mm'=. if card2type`mm'==0 | card2type`mm'==9
replace card3type`mm'=. if card3type`mm'==0 | card3type`mm'==9
replace card4type`mm'=. if card4type`mm'==0 | card4type`mm'==9
}
*Count number non-missing observations for each category of reporting
egen nonmissUNF = rownonmiss(card0type*)
egen nonmissACT = rownonmiss(card1type*)
egen nonmissCLRD  = rownonmiss(card2type*)
egen nonmissCLRD18  = rownonmiss(card3type*)
egen nonmissLEOKA  = rownonmiss(card4type*)
*Drop ORI without population
sum pop1 if pop1==0
*146375 ori without population
*Create corrected population
gen pop_corr=pop
egen pop_mean=mean(pop), by(ori)
egen check=mean(pop1), by(ori)
gen misspop=(pop1==0 & check>0)
replace pop_corr=pop_mean if misspop==1
*Drop ORI in multiple counties
sum pop2 if pop2>0
*15447 ori in multiple counties
*Generate FIPS county code
gen fipscounty_00="0"+string(FSTATE)+"00"+string(FCOUNTY) if FSTATE<10 & FCOUNTY<10
replace fipscounty_00=string(FSTATE)+"00"+string(FCOUNTY) if FSTATE>=10 & FSTATE!=. & FCOUNTY<10
replace fipscounty_00="0"+string(FSTATE)+"0"+string(FCOUNTY) if FSTATE<10 & FCOUNTY>=10 & FCOUNTY<100
replace fipscounty_00=string(FSTATE)+"0"+string(FCOUNTY) if FSTATE>=10 & FSTATE!=. & FCOUNTY>=10 & FCOUNTY<100
replace fipscounty_00="0"+string(FSTATE)+string(FCOUNTY) if FSTATE<10 & FCOUNTY>=10 & FCOUNTY>=100 & FCOUNTY!=.
replace fipscounty_00=string(FSTATE)+string(FCOUNTY) if FSTATE>=10 & FSTATE!=. & FCOUNTY>=10 & FCOUNTY>=100 & FCOUNTY!=.
destring fipscounty_00, replace force
*Generate FIPS place code
gen fipsplace_00="0"+string(FSTATE)+"000"+string(FPLACE) if FSTATE<10 & FPLACE<100
replace fipsplace_00=string(FSTATE)+"000"+string(FPLACE) if FSTATE>=10 & FSTATE!=. & FPLACE<100
replace fipsplace_00="0"+string(FSTATE)+"00"+string(FPLACE) if FSTATE<10 & FPLACE<1000 & FPLACE>=100
replace fipsplace_00=string(FSTATE)+"00"+string(FPLACE) if FSTATE>=10 & FSTATE!=. & FPLACE<1000 & FPLACE>=100
replace fipsplace_00="0"+string(FSTATE)+"0"+string(FPLACE) if FSTATE<10 & FPLACE<10000 & FPLACE>=1000
replace fipsplace_00=string(FSTATE)+"0"+string(FPLACE) if FSTATE>=10 & FSTATE!=. & FPLACE<10000 & FPLACE>=1000
replace fipsplace_00="0"+string(FSTATE)+string(FPLACE) if FSTATE<10 & FPLACE!=. & FPLACE>=10000
replace fipsplace_00=string(FSTATE)+string(FPLACE) if FSTATE>=10 & FSTATE!=. & FPLACE!=. & FPLACE>=10000
destring fipsplace_00, replace force

///Aggregate data at year level
*Sum every crime at year level (if values not missing>=9) and rescale by number of months for which it is updated
forvalues i=1/26{
egen tot_offensesunf_`i'c = rowtotal(offensesunf_`i'c*) if nonmissUNF >=9
g totn_offensesunf_`i'c = (12/nonmissUNF)*tot_offensesunf_`i'c
egen tot_offenses_`i'c = rowtotal(offenses_`i'c*) if nonmissACT >=9
g totn_offenses_`i'c = (12/nonmissACT)*tot_offenses_`i'c
egen tot_clearances_`i'c = rowtotal(clearances_`i'c*) if nonmissCLRD >=9
g totn_clearances_`i'c = (12/nonmissCLRD)*tot_clearances_`i'c
egen tot_clearancesu18_`i'c = rowtotal(clearancesu18_`i'c*) if nonmissCLRD18 >=9
g totn_clearancesu18_`i'c = (12/nonmissCLRD18)*tot_clearancesu18_`i'c
}

///Create unique Indianapolis ori
gen indianapolis=(ori=="IN04900" | ori=="INIPD00")
foreach var of varlist pop1 pop pop_corr tot*offensesunf_* tot*offenses_* tot*clearances_* tot*clearancesu18_*{
egen `var'_ind=total(`var') if indianapolis==1, by(year)
replace `var'=`var'_ind if ori=="INIPD00"
drop `var'_ind
}
drop if ori=="IN04900"
drop indianapolis

///Aggregate data at county-year level
*Sum population in jurisdiction of ori at county level
egen tot_cty_oripop1=total(pop1), by(fipscounty_00 year)  missing
egen tot_cty_oripop=total(pop), by(fipscounty_00 year)  missing
egen tot_cty_oripop_corr=total(pop_corr), by(fipscounty_00 year)  missing
egen tot_cty_numori=seq(), by(fipscounty_00 year)
*Sum every crime at county level
forvalues i=1/26{
egen totn_cty_offensesunf_`i'c=total(totn_offensesunf_`i'c), by(fipscounty_00 year) missing
gen totnpc_cty_offensesunf_`i'c=totn_cty_offensesunf_`i'c/tot_cty_oripop
gen totnpcc_cty_offensesunf_`i'c=totn_cty_offensesunf_`i'c/tot_cty_oripop_corr
egen totn_cty_offenses_`i'c=total(totn_offenses_`i'c), by(fipscounty_00 year)  missing
gen totnpc_cty_offenses_`i'c=totn_cty_offenses_`i'c/tot_cty_oripop
gen totnpcc_cty_offenses_`i'c=totn_cty_offenses_`i'c/tot_cty_oripop_corr
egen totn_cty_clearances_`i'c=total(totn_clearances_`i'c), by(fipscounty_00 year)  missing
gen totnpc_cty_clearances_`i'c=totn_cty_clearances_`i'c/tot_cty_oripop
gen totnpcc_cty_clearances_`i'c=totn_cty_clearances_`i'c/tot_cty_oripop_corr
egen totn_cty_clearancesu18_`i'c=total(totn_clearancesu18_`i'c), by(fipscounty_00 year)  missing
gen totnpc_cty_clearancesu18_`i'c=totn_cty_clearancesu18_`i'c/tot_cty_oripop
gen totnpcc_cty_clearancesu18_`i'c=totn_cty_clearancesu18_`i'c/tot_cty_oripop_corr
}

save rawdata\UCR\data_ucr_ori, replace
